Google Spreadsheets - Display date of each weekday of current week

by DolbyOver   Last Updated July 18, 2018 18:03 PM

I have seven spreadsheets, one for each day of the week. I am trying to get each one to display their date for that week. So for example, this week the Monday would display 7/16/2018 and the Tuesday spreadsheet would display 7/17/2018. Even if it is Monday, I wanna be able to open the Tuesday spreadsheet and have it display the date of what that upcoming Tuesday will be. I've been messing around with different formulas and cant figure it out.

Related Questions

Import range from 3 sheets/tabs into 4th

Updated February 06, 2019 12:03 PM

Aggregate results by week and month for charts

Updated January 18, 2019 09:03 AM