Calculate date for 1st Monday of last week

[Manny Singh]

Hi All,

Could you please help writing a formula that will calculate date for 1st Monday of last week, in this case: 17/10/2016

And a separate formula to calculate date for Friday (week end) of last week.

Thanks in advance.

Cheers,
Manny

 

[Nebu]

Hi:
For last week's Monday
=TODAY()- (WEEKDAY(TODAY(),2)+6)
For last week's Friday
=TODAY()- (WEEKDAY(TODAY(),2)+2)

Thanks