Formula Help to return every Friday's date and after?

[zone709]

HI trying to get a formuala to return every fridays date. So tomorrow is friday it would return 12/14/2018. Once friday pasts i need it to return next Fridays date -- Example would be 12/21/2018

and on thanks

 

[MARK858]

Maybe....

=TODAY()+7-WEEKDAY(TODAY()+1)

 

[Fluff]

Assuming your date is in A2 try
=A2+7-WEEKDAY(A2+7-6)

 

[zone709]

thanks guys for the help...

 

[Fluff]

You're welcome & thanks for the feedback

 

[zone709]

Hi i also needed it for Sunday. So i did thi will this work?

=TODAY()+9-WEEKDAY(TODAY()+1)

 

[mrshl9898]

That's the next Sunday, so =TODAY()+2-WEEKDAY(TODAY()+1)

 

[zone709]

That's the next Sunday, so =TODAY()+2-WEEKDAY(TODAY()+1)

Ok great thanks for the reply. I thought i did it right but i think i get it.

 

[MARK858]

I thought you were after the next Sunday (as you wanted with the Friday) and not the previous one (which is what mrshl9898 posted does).

If that is the case try

=TODAY()-WEEKDAY(TODAY()-1)+7

You'll see the difference between the formula above and the formula in post number 6 if you change your computers date to the 16th.