Formula return following Wednesday or Friday date.

Need a formula for cell J27 that returns the date of the following Wednesday from a date in cell J2 that's a Wed, Thurs, or Fri
or
return the date of the following Friday for a date in cell J2 that's Sat, Sun, Mon, or Tue.

For example, when 05-29-08, a Thursday, is entered in cell F2, I need cell J27 to return the following Wednesday's date of 6-04-08.
or
For example, when 06-01-08, a Sunday, is entered in cell F2, I need cell J27 to return the following Friday's date of 06-06-08.

Thank you for your help. mikeburg
For example,

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

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

Both formula's now seem to work.

mikeburg

Ok, so I tried that formula and it looks like it works fine however I am returning two days prior to that Friday as marked on the 2010 calendar??

I am trying to have the return date be the following Friday (pay date).

So M3 contains a date and I need N3 to return the Friday date that follows what ever date is in M3. Help?