I have a cell(C27) with the foumula:
=TODAY()+1
When I open the file on Friday, it shows Saturday.
I want it to show Monday.
How do I modify the formula if C21 is Saturday(6), then Weekday +2
My formula that doesn't work is:
=IF(TODAY()+1=WEEKDAY(6),TODAY()+3)
Am I close???

Joe