What is the formula to return the dates of Monday and Friday of last week.
I am posting this on Tuesday, June 5, 2018. I am looking for formulas that will return 5/28/2018 and 6/1/2018.
google sheets
What is the formula to return the dates of Monday and Friday of last week.
I am posting this on Tuesday, June 5, 2018. I am looking for formulas that will return 5/28/2018 and 6/1/2018.
Best Answer
=TODAY()