Print last week from a range of Dates

[Dinesh_Excel]

Hello Friends,

I was trying to print last week from a range of dates .But the fornula is partially working.
Need your help on the same.


=IF(MEDIAN(TODAY()-WEEKDAY(TODAY()-2)-7,A2,TODAY()-WEEKDAY(TODAY()-2)-7+5)=A2,"Last Week","")

3rd sep to 9th Sep should print as "Last Week"
10th Sep to 16th Sep as "Blank"


This would continue as the weeks goes on....



Apprecaite your help on the same

 

[bosco_yip]

Try,

B2, copied down :

=IF(MEDIAN(TODAY()-WEEKDAY(TODAY(),17)-6,A2,TODAY()-WEEKDAY(TODAY(),17))=A2,"Last Week","")

Regards
Bosco

 

[p45cal]

You can try a formula like this - it may need a small tweak if your date system is different from mine:
=IF(INT(TODAY()/7)-INT((A2-1)/7)=0,"This week",INT(TODAY()/7)-INT((A2-1)/7) & " week(s) ago")



the -1 week(s) ago is the future!
See attached.

edit post posting:
Actually, I've not given you what you asked for; try in cell B2:
=IF(INT(TODAY()/7)-INT((A2-1)/7)=1,"Last week","")
which only shows last week as 'Last week', everything else is blank.

 

[Dinesh_Excel]

Thanks p45cal for your help....appreciate your help