Dear all,
I have the cell C5 with the date "2008-12-01".
In cell D5 I want the date of the next month, so in Excel I would use:
=DATE(YEAR(C5);MONTH(C5)+1;DAY(C5))
Note that I'm incrementing the month value. In GridWeb this is not working, it returns "#NUM" when it needs to overlap the year, is this normal?
Best regards,
Nelson Ruivo