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.