I am trying to allocate days between a date range into years.
Start Date 16-2-2012 End Date 01/3/2015. There are 1109 days between this range.
I need to spread 319 days into 2012, 365 into 2013, 365 into 2014 and 60 days into 2015.
The file attached will do the allocation for 2012,2013,2014 but I need to add something to the formula so it puts the last 60 days into 2015.
I am assing a full year ends on the 31 December.
Is anyone able to help modify the formula in the file attahed.
Thanks for your help