Date formula need to determine last week's date
Date formula need to determine last week's date
(OP)
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?
RE: Date formula need to determine last week's date
hi,
Generally speaking this past Monday's data can be calculated as (in Excel syntax)..
=INT((Today()-2)/7)*7+2
The PREVIOUS Monday would simply be 7 days less.
Skip,
Just traded in my old subtlety...
for a NUANCE!
RE: Date formula need to determine last week's date