Hi,
I know this is really simple but I'm having a bit of a brain block right now.
=IF(C2="","",MONTH(C2)+5)
Is my basic formula, where Column C is full of dates in DD/MM/YYYY format
The problem of course is that it cannot handle year breaks, so January will revert the result back to 1 (+5)
I want it to add an additional 12 for every year beginning 2011 without having to have to do it manually along the lines of:
=IF(C2="","",MONTH(C2)+5+12) for 2011
=IF(C2="","",MONTH(C2)+5+12+12) for 2012
etc
I was thinking of using MATCH or CHOOSE.
[edit]
Came up with this, but seems overly complicated:
=IF(EP2="",IF(C2="","",MONTH(C2)+5+12*(YEAR(C2)-2010)),EP2)
Bookmarks