Display Date

  • Thread starter Thread starter Ayanna
  • Start date Start date
A

Ayanna

I am thoroughly stumped! I would like a formula that does
the following:
If current DAY equals Friday, then display tomorrow's
DATE; If current DAY equals Monday, then display past
Saturday's DATE.
Is this even possible...or is it asking too much of a
spreadsheet?
Thanks!
 
Ayanna

Try this:
=IF(WEEKDAY(TODAY())=6,TODAY+1,IF(WEEKDAY(TODAY())=2,TODAY()-2,""))

Andy.
 
Sorry, missed a bracket.

=IF(WEEKDAY(TODAY())=6,TODAY()+1,IF(WEEKDAY(TODAY())=2,TODAY()-2,""))

Andy.
 
One way

=IF(WEEKDAY(TODAY(),2)=5,TODAY()+1,IF(WEEKDAY(TODAY(),2)=1,TODAY()-2,""))

it will return blank if today's date is not a Friday or a Monday
 
Try this

=IF(WEEKDAY(NOW())=6,NOW()+1,"something else")

6 = Friday

Format the cell as a date
 
W-O-W...THANKS!!!!!!
-----Original Message-----
One way

=IF(WEEKDAY(TODAY(),2)=5,TODAY()+1,IF(WEEKDAY(TODAY(),2) =1,TODAY()-2,""))

it will return blank if today's date is not a Friday or a Monday

--

Regards,

Peo Sjoblom





.
Click to expand...
 
Back
Top