yogi_For Specified Weekday Compute Dates for Current Week And Future Weeks

Google Spreadsheet   Post  #2239

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-15-2017
question by: xboxps4

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/Q8fczkRIngA;context-place=mydiscussions

Working out a day/date within a week ahead all the time

Hello guys,

I'll try to explain this as best as I can.  Basically I want google sheets to calculate a date based on the upcoming friday every week.  

So for example, for me today is Tue 12th Sept, so what is the upcoming friday's date?

All google sheets needs to do is give me the upcoming friday's date, so that each time I go into that spreadsheet it should have the date.

I assume this is possible based on the TODAY() formula?

Thanks very much