Return Future Weekday

[sports_fan]

Say in cell A1 I have the date 01/21/2013. Is there a formula I can use in B1 to return the following Wednesday (in this case 01/23/2013)?

[rcm]

insert this in b1 and will give you the following WED date

Please Login or Register  to view this content.

[jeffreybrown]

Maybe

=A1+7-WEEKDAY(A1+3)

[sports_fan]

I think I understand how that works. Thank you rcm.

[sports_fan]

Maybe

=A1+7-WEEKDAY(A1+3)

This will work too. Thank you both.

[rcm]

you are welcome

[[email protected]]

Here is another way
=IF(WEEKDAY(A1)=1,A1+3,A1-(WEEKDAY(A1)-4))
Having Sunday = 1, which is the beginning of the week