If I have a date in a cell, increase it by 1, it will become the next day...If I have a random month-end date i.e. 31 March, how do you get an increase to take it to the end of the next month? Adding 30, in this case, takes it to 30 April which is fine, but if my start date was 31 January and I add 30 it takes me into March, not the end of February.
Anyone know or got any ideas?
Thanks
Bookmarks