Date formula need to determine last week's date

[MicWalklin]

I need to create a view to display last week's announcements based on Posting Date Column. how do I create a calculated column to get beginning/end of Last week?

 

[SkipVought]

hi,

Generally speaking this past Monday's data can be calculated as (in Excel syntax)..
[tt]
=INT((Today()-2)/7)*7+2
[/tt]
The PREVIOUS Monday would simply be 7 days less.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MicWalklin]

Thank you but I thought TODAY wasn't allowed in Sharepoint calculated columns?