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 G@discussions.microsoft.com> wrote in message
news:1F5A7736-1916-4155-8DC9-954218292491@microsoft.com...
> 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
>