Formula return following Wednesday or Friday date.

Thank you for your response, but I can't get the formula to work.

Any other ideas? mikeburg

Does this work for you, Mike?

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

No. However, using either formula in cell J27 causes the date of 1/06/00 when it should be the following Friday, 6-06-08 (cell F2 has 06/01/08).

I have both J2 & J27 formatted 03/14/01, if that means anything.

Thanks for the help. Any other ideas? mikeburg

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