LinkBack URL
About LinkBacks
Is there a way to make the date in a cell check the current date then fall back to the previous sunday unless today actually happens to be sunday? So for example it would look at today and make the date 12/9/2007 rather than 12/14/2007
Is there a way to make the date in a cell check the current date then fall back to the previous sunday unless today actually happens to be sunday? So for example it would look at today and make the date 12/9/2007 rather than 12/14/2007
=today()-weekday(today())+1
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
That works perfectly, thank you very much.
How would I correct the formula so that the cell would always present the date as the next Sunday unless it is Sunday? I'm trying on my own but I'm a bit of a newbie...
Last edited by Superhatch; 12-17-2007 at 11:18 AM.
=TODAY()+WEEKDAY(TODAY())+4 works for this week, but I'm not sure why, or if it will work for next week, any correction or explanation would be greatly appreciated.
Try this,
=TODAY()+7-WEEKDAY(TODAY())+1
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks