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
Bookmarks