Help...how to print last week dates separately in new Column

[Dinesh_Excel]

Hi Friends,

I have a range of dates where I need to print all the last week dates in a seperate column as "LAST WEEK"

Eg:

Have dates from in column A from Jan 1st 2017 till today (23rd August 2017).

In column B it should print as "last week" for the dates ranging from 14 august to 18th August.

similarly, this should be flexible as the month moves ahead.

Appreciate your help on the same

Thanks

 

[Chihiro]

It'd help if you upload sample workbook.

Assuming that dates are actual date values in Column A.
Try...
=IF(WEEKNUM(A2,2)=WEEKNUM(TODAY(),2)-1,"Last Week","")

Note: This won't work if you have more than 1 year's worth of dates listed.

 

[Chihiro]

If you have more than 1 year's worth of dates listed. Try...
=IF(MEDIAN(TODAY()-WEEKDAY(TODAY()-2)-7,A2,TODAY()-WEEKDAY(TODAY()-2)-7+5)=A2,"Last Week","")

 

[Dinesh_Excel]

Thanks Chihiro ..it worked

Appreciate your help