Date
 

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

Date
 

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

Date
 

On Mon, 18 Apr 2005 07:15:02 -0700, "David G" <David
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