Problem with date formula 1

[ADE6]

Hi

I have the follwing date formula,it is meant to give today's date if it is a workday and before 10 PM,after 10 PM the date is meant to roll forward to the next workdays date.


=IF(HOUR(NOW())<22,WORKDAY(TODAY(),IF(OR(WEEKDAY(TODAY())=1,WEEKDAY(TODAY())=7),1,0)),WORKDAY(TODAY(),1))

This formula was working for most of the week but now it is showing Thursdays date when it should be showing Fridays.My pc clock is showing the right time.


Can anybody spot any errors in it


Thanks for the help

Ade

 

[bluedragon2]

What will this do for you:

=IF(HOUR(NOW())<22,WORKDAY(TODAY(),0),WORKDAY(TODAY(),1))

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...