Google-sheets – How to get the date of Monday and Friday of last week

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.

=A1-WEEKDAY(A1)-1
=A1-WEEKDAY(A1)-5

Let B2 the cell containing the date.

=IF(WEEKDAY(B2)=2, B2, IF(WEEKDAY(B2)=1,B2+1, B2+9-WEEKDAY(B2)))

=IF(WEEKDAY(B2,3)=0, B2, B2+7-WEEKDAY(B2,3))

Perhaps in a helper column (say B assuming data is in A):

=if(year(A1)=year(now()),weeknum(A1),"")

to identify entries in the latest 10 weeks (by week number) by row and a table in rows1:10 of:

=weeknum(now())-10+ROW()

for one column (say E) and:

=countif(B:B,E1)

for another, with all formulae copied down to suit.