raccoon588
Board Regular
- Joined
- Aug 5, 2016
- Messages
- 118
I am looking for a formula that no matter what today date is it will always return the dates for the following Saturday and Sunday.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Weekends no matter the current day
- Thread starter raccoon588
- Start date
mikerickson
MrExcel MVP
- Joined
- Jan 15, 2007
- Messages
- 24,355
If you have a date in A1
=CEILING(A1+1, 7) will return the date of the next Saturday.
=CEILING(A1,7) + 1 will return the date of the next Sunday.
=CEILING(A1+1, 7) will return the date of the next Saturday.
=CEILING(A1,7) + 1 will return the date of the next Sunday.
Upvote
0
