I have certain date in certain cell. I need a formula that can automatically change the month when the month changes. E.g. I have entered 20th Apr. 2017 in a cell and I want that this 20th Apr. 2017 becomes 20th May, 2017 when May starts. The formula should not have to refer to any kind of reference cell/range. It should be only a formula that I could put in a cell for Nth day of the month.
Thanks
Nadim
Try this:
=DATE(YEAR(TODAY()),MONTH(TODAY()),20)
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.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
One way:
=--TEXT(TODAY(),"yyyy/mm/\2\0")
Dear all,
Thank you so much for your guidance.
Have a nice day.
Thanks
Nadim
What would be the formula a) if I want to change the date Yearly instead monthly and b) if I want to change the date after every 15 days from a given date, say 11th Apr. 2017?
Thanks
Nadim
Last edited by nadimqaisar; 04-20-2017 at 08:38 AM.
The formula I gave you can be adapted. Let's say you always want 20 April and just change the year, use this:
=DATE(YEAR(TODAY()),4,20)
If you want to change the date every 15 days, then maybe this:
=DATE(YEAR(TODAY()),MONTH(TODAY()),A1)
where A1 contains the number (e.g. 15) that you want to change the date to.
It's all quite flexible - open a new workbook and have a play with various options. Don't be afraid!
Thank you so much Ali
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks