Return Future Weekday

**sports_fan** · 01-09-2013, 11:05 PM

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** · 01-09-2013, 11:11 PM

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

Please Login or Register  to view this content.

**jeffreybrown** · 01-09-2013, 11:16 PM

Maybe

=A1+7-WEEKDAY(A1+3)

**sports_fan** · 01-09-2013, 11:34 PM

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

**sports_fan** · 01-09-2013, 11:50 PM

Originally Posted by jeffreybrown

Maybe

=A1+7-WEEKDAY(A1+3)

This will work too. Thank you both.

**rcm** · 01-09-2013, 11:53 PM

you are welcome

**jjtalfama@aol.com** · 01-10-2013, 01:08 AM

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

Re: Return Future Weekday