Problem with workday 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.

This works ok during the week,but for example today it is showing Saturdays date when i want it to show Mondays date(the next workday)



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

Cell U3 contains the TODAY() formula


Thanks for the help

Ade

 

[SkipVought]

Ade
[tt]
=IF(HOUR(NOW())<22,WORKDAY(TODAY(),IF(OR(WEEKDAY(TODAY())=1,WEEKDAY(TODAY())=7),1,0)),WORKDAY(TODAY(),1))
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884