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

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

Thank you very much. I do have the Analysis installed. Super simple.

Joe

"JE McGimpsey" wrote in message
...
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