Formula return following Wednesday or Friday date.

If J2 contains the date 1-Jun-08 then the formula I suggested will return 6-Jun-08, isn't that the correct result?

Note: the formatting should make no difference as long as J2 contains a date

Yes, 6-Jun-08 is the correct result.

However, my result is coming up as 06-Jan-00. I just can't understand why.

mikeburg

Are you sure the formula is referencing the correct cell. The formula I suggested;

=CHOOSE(WEEKDAY(J2),5,4,3,7,6,5,6)+J2

will show 6-Jan-00 only if J2 is blank

That's what's wrong. I had the date in the wrong cell. Thanks a million!

Both formula's now seem to work.

mikeburg