Date and Time functions

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I need a cell to display the date, switch to the next date
at 2:00 pm, and skip Saturdays and Sundays. For example,
now it should display 3/15/04. At 3:00pm it should
display 3/16/04. On Saturday the 20th, it should display
3/22/04.

Right now, I am using this:
=IF(MOD(NOW(),1)>=14/24,TODAY()+1,TODAY())

The problem I have is getting the cell to skip weekends.
 
Hi Sam
so on the weekend it should always display monday?
Try the following
=IF(WEEKDAY(TODAY(),2)>5,WORKDAY(TODAY(),1),IF(MOD(NOW(),1)>=14/24,TODA
Y()+1,TODAY()))
 
Replace

TODAY()+1

with

WORKDAY(TODAY(),1)

WORKDAY is a function in the Analysis Toolpak Addin (Tools/Addins...)
 
Hi
A small addition for Fridays. make this
=IF(OR(WEEKDAY(TODAY(),2)>5,MOD(NOW(),1)>=14/24),WORKDAY(TODAY(),1),TOD
AY())
 
Back
Top