Quote:
Originally Posted by kelwea
Did you just use cell formatting to get the desired output in the cell?
|
Yes, all the cells concerned contain full-blown Excel dates
Quote:
Originally Posted by kelwea
And why did you have to use EDATE in Apr - Dec and not in the first tab?
|
The EDATE formula returns a date n months forwards or backwards and takes account of leap years and the different numbers of days in the months. It's not needed for the first tab since the date (1st Jan) IS the date on the reference sheet.
ps. I think I missed adding conditional formattting to the March-April boundary too.