Date

[David G]

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

[Tom Ogilvy]

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
>

[Ron Rosenfeld]

On Mon, 18 Apr 2005 07:15:02 -0700, "David G" <David
G@discussions.microsoft.com> wrote:

>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

Was there some problem with the responses in .misc?

It would be helpful if you would respond there instead of multi posting.


--ron