what happens if adding 2 would put it as the 1st or second day of the next
month (essentially month + 2)?

--
Regards,
Tom Ogilvy


"David G" <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