Next day Date, no weekends

[robfo0]

Hi everyone,

This should be a pretty easy question. i have a cell on a worksheet which i need to be automatically updated when the sheet is opened. I would like the value to be the day after todays date, UNLESS that date is a saturday or sunday. In that case, i would like it to be the following monday's date. I was thinking something easy like =Today() +1 , but then Im not sure how to detect saturday or sunday.

Thanks any help is appreciated

 

[razzandy]

Try Thisin B2:
=WORKDAY(A2,1) if A2 is where your date is stored!
Hope this helps! Try searching the help files for WORKDAYS!

Ryan UK
This message was edited by razzandy on 2002-09-13 17:58

 

[bigbob]

[No message]