I am currently using a formula in Excel that returns next Sunday from a given date:
=(TODAY()+8-WEEKDAY(TODAY()-7))
How can I write a formula that will return the next Sunday even if the current Sunday hasn't happened yet? Example, Sunday-Thursday, I'd like to return the next Sunday, however Friday-Saturday, I'd like to ignore the upcoming Sunday and return the Sunday for the following week.
The reason for this is I print out overtime reports for Week Ending: (insert date for following Sunday). I would like to be able to print these reports out on Friday if overtime is not being worked over the weekend, without having to wait to print out Monday morning.
Bookmarks