Hello,
I want to be able to display a date for the following Sunday based off of the current date, so if today is 12/19/2017 and the follow Sunday is 12/24/2017 this date 12/24/2017 will be inputted to a certain cell. Is there a formula or will VBA need to be used to accomplish this task? This is mind boggling!
Thanks in advance for the assistance!
LeapingLizard
What should happen if the current data IS a Sunday?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Like this?
=INT(DATE(2017,12,19)/7)*7+8
Teach me Excel VBA
and of course you can refer the cell of the date instead of 2017,12,19
ALi,
The answer to your question is yes! Thanks
Thanks ImranBhatti, so to input respective dates for the rest of the week into the spreadsheet so the dates are consistent with the calendar?
Example : Currently the dates for the week are inputted off of me entering the Sunday's date into the spread sheet(a2). The formula I have used is (A2+1) to populate Monday's date and (A2+2) for Tuesday's date and so forth......
Correct me if I am wrong, but I the way I have these dates inputting it will go to 31 days in the month all the time.
Hopefully that makes sense. I want it to increment the next date based off the current calendar year.
Thanks,
LeapingLizard
Not clear about the rest of the requirement.If you want to get the next days of the week you need to use A1(or the cell where the first formula resides)+1 And if you want to get every other Sunday then use =A1+7 . If I am not understood correctly then I would suggest you to please upload a sample workbook with a manual example results
Do not sweat it, I think I have it figured out. Thanks!
How can the answer to, “What happens if ... ?” be “Yes”?Originally Posted by LeapingLizard
For the sake of completeness, please explain how you solved this issue.
Once you have done this, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
This works as long as you are using default 1900 date system - with 1904 date system it returns a Saturday
This formula will return the following Sunday based on today's date - it works with both date systems
=TODAY()+8-WEEKDAY(TODAY())
On a Sunday that will return the date of the following Sunday
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks