# Thread: formula to display Last Week, This Week Thanks: 0 Likes:  1 Post #5322794 (1)

1. ## formula to display Last Week, This Week

=IF(H2<TODAY()-14,"Old",IF(H2<TODAY()-7,"Last Week", "This Week"))

I found this formula and my only issue is that I want the week to start from Monday to Sunday.. for last week and this week.

2. ## Re: formula to display Last Week, This Week

Something like this function.

Excel 2013/2016
AB
1DateWeek Starting Monday
2Thursday, August 08, 2019Monday, August 05, 2019

Sheet1

Worksheet Formulas
CellFormula
B2=A2-WEEKDAY(A2,2)+1

3. ## Re: formula to display Last Week, This Week

Originally Posted by Sam_D_Ben
Something like this function.

Excel 2013/2016
AB
1DateWeek Starting Monday
2Thursday, August 08, 2019Monday, August 05, 2019

Sheet1

Worksheet Formulas
CellFormula
B2=A2-WEEKDAY(A2,2)+1
A helper column! Got it. =D Thank you!

4. ## Re: formula to display Last Week, This Week

Or try

=IF(WEEKNUM(TODAY(),2)=WEEKNUM(H3,2),"This Week",IF(WEEKNUM(TODAY()-7,2)=WEEKNUM(H3,2),"Last Week"))

5. ## Re: formula to display Last Week, This Week

Originally Posted by Phuoc
Or try

=IF(WEEKNUM(TODAY(),2)=WEEKNUM(H3,2),"This Week",IF(WEEKNUM(TODAY()-7,2)=WEEKNUM(H3,2),"Last Week"))
Phuoc, this works!! I was trying to accomplish to write this. Thanks so much!!