WEEKDAY using IF

  • Thread starter Thread starter lunker55
  • Start date Start date
L

lunker55

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change to formula to make it go to next weekday (i.e., avoid weekend days)? 5
Count the Number of Weekdays by Month 3
WEEKDAY 7
Find number of weekdays and wekend days given a total number of da 7
Weekdays between two dates in Excel? 1
Date plus month, year, or years in workdays 5
Limit TODAY() to weekdays only 4
convert spreadsheet formula into VBA formula 1

Back
Top