MicWalklin
Programmer
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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date formula need to determine last week's date
- Thread starter MicWalklin
- Start date
- Status
SkipVought
Programmer
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,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...for a NUANCE!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
- Thread starter
- #3
MicWalklin
Programmer
Thank you but I thought TODAY wasn't allowed in Sharepoint calculated columns?
- Status
Similar threads
- Locked
- Question