Thank you very much Claus. Your super formula did the trick in column AL.
But in column AM, the formula gives the same answer as column AL

Just to clarify. Column AL is for CY (calendar year 15) which means Jan 15 to Dec 15. The formula works perfect here

Column AM is for FY (financial year 15-16) which means Jul 14 to Jun 15.
Different period range here. So if I copy formula from column AL to AM, givers me the same answer as AL

New file attached which shows this http://s000.tinyupload.com/?file_id=...74053143686186

Thanks heaps. Always been of great assistance