formula to display Last Week, This Week

[pcorpz]

=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.

 

[Sam_D_Ben]

Something like this function.

Excel 2013/2016
	A	B
1	Date	Week Starting Monday
2	Thursday, August 08, 2019	Monday, August 05, 2019
Sheet1

Cell Formulas
Range	Formula
B2	=A2-WEEKDAY(A2,2)+1

 

[pcorpz]

Something like this function.

Excel 2013/2016
	A	B
1	Date	Week Starting Monday
2	Thursday, August 08, 2019	Monday, August 05, 2019
Sheet1

Cell Formulas
Range	Formula
B2	=A2-WEEKDAY(A2,2)+1

A helper column! Got it. =D Thank you!

 

[Phuoc]

Or try

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

 

[pcorpz]

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