Hi Franz

no apology necessary ....

--
Cheers
JulieD

"Franz" wrote in message
...
Hi Julie

I'm sorry...
Sometimes I should read better...
Your formula was very good

Hope you will forgive me

Also for my English...

Bye

Franz


"JulieD" ha scritto nel messaggio
...
Hi Franz

why better?

--
Cheers
JulieD

"Franz" wrote in message
...
I think it could be better in this way:

=IF(WEEKDAY(DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)))=7, 2,IF(WEEKDAY(DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)))=1 ,1,DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)))

Bye

Franz


"JulieD" ha scritto nel messaggio
...
Hi David

there is a weekday function which tells you what day of the week an
event is (by default it puts Sunday as 1) so you could do something
like this:

=DATE(YEAR(F3),MONTH(F3)+1,DAY(F3))+IF(WEEKDAY(DAT E(YEAR(F3),MONTH(F3)+1,DAY(F3)))=7,2,IF(WEEKDAY(DA TE(YEAR(F3),MONTH(F3)+1,DAY(F3)))=1,1,0))

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"David" wrote in message
...
I have a series of dates in column f, and the formula is
DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)), but I need to check if this date
is a
weekend or weekday. Let us say 06/18/05 is a saturday, I need that
cell to
display 06/20/05, is that possible. Any help you can provide would be
greatly appreciated.

Thanks in advance