One way:
=IF(WEEKDAY(TODAY())5,TODAY()-WEEKDAY(TODAY(),3)+7,TODAY()+1)
another, if you have the Analysis Toolpak Add-in loaded (Tools/Addins..):
=WORKDAY(TODAY(),1)
In article ,
"lunker55" wrote:
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
|