ExcelBanter - WEEKDAY using IF

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - WEEKDAY using IF (https://www.excelbanter.com/excel-discussion-misc-queries/1226-weekday-using-if.html)

lunker55

WEEKDAY using IF

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

JE McGimpsey

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

lunker55

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

All times are GMT +1. The time now is 09:56 PM.