Complete Tax Years

[DAVES]

Hi there
I'm looking for a function to calculate the number of complete tax years (6apr to following 5apr) between 2 given dates. I would be grateful for any advice
Thanks
Dave

 

[Norman Harker]

Hi Daves!

Try:
=DATEDIF(IF(A1<DATE(YEAR(A1),4,6),DATE(YEAR(A1),4,6),DATE(YEAR(A1)+1,4,6)),IF(B1<DATE(YEAR(B1),4,6),DATE(YEAR(B1)-1,4,6),DATE(YEAR(B1),4,6)),"y")

But check whether the boundary dates are treated right (i.e. you're
happy with calcs where the dates in A1 and B1 are 5th or 6th Apr)

 

[DAVES]

Excellent

Thanks for this Norman

Dave

 

[Norman Harker]

Hi Dave!

And now for some useless information:

Apr-6 less 11 days is 26-Mar.
26 of Mar used to be the first day of the year before the 1752 British
adoption of Gregorian calendar reform.
The 11 days was the adjustment made to the calendar in that year which
was the first year to officially end on 31-Dec.
But the government didn't want to mess with the revenue so they added
11 days to the old year basis and introduced the 6-Apr start to the
FY.

The change in calendar upset quiet a lot of people, there were riots
in Hexham, Northumberland where people felt that 11 days were being
stolen from their life