I need to show the date of the previous weeks Sunday date and Saturday date. I came across the following formula, and it works well to show me the previous weeks Saturday but not the previous weeks Sunday. any help would be much appreciated! thanks
=TODAY()-CHOOSE(WEEKDAY(TODAY()),6,5,4,3,2,17)
=TODAY()-CHOOSE(WEEKDAY(TODAY()),1,2,3,4,5,6,7)
Hi,
For Sunday you could try the following:
=TODAY()-CHOOSE(WEEKDAY(TODAY()),7,1,2,3,4,5,6)
This really depends on how you define "Previous Saturday and Sunday". Specifically, what should happen if Today is Sunday? Is the day before the Previous Saturday with the day the Previous Sunday being one week previous? (etc.)
S
------------------------------------------------------------------------------------------
If you need no more help on the current problem, please mark it as "Solved". It saves time
as many of us will look at threads if they are not marked as "Solved".
The instructions on how to do this are found in the Forum Rules thread that is at top of every forum.
(Currently you'll have to look at point #9.)
------------------------------------------------------------------------------------------
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks