Looking for a date formula that adds one month to the date whereby if you enter say MAY06 (exactly that format) in cell A1, cell A2 returns month end 30/06/06.
Looking for a date formula that adds one month to the date whereby if you enter say MAY06 (exactly that format) in cell A1, cell A2 returns month end 30/06/06.
Well this seems to work
=DATE(YEAR(A1),2+(MONTH(A1)),1)-1
you can format the cells anyway you want
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks