I know this is really simple but I'm having a bit of a brain block right now.
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
I was thinking of using MATCH or CHOOSE.
Came up with this, but seems overly complicated: