Friday, September 15, 2017

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!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