Date Functions - Tax Years

Hi

I would be really gratfeul if someone could help me with a problem.

I need to count completed tax years (ie 6 April to 5 April) between two given dates.

Also I need to be able to count 6th Aprils passed between two dates (although I think just adding one to the above will work it out).

Many thanks
Agni

If your dates are A1 and B1, with B1 > A1 then this formula should give a count of complete tax years

=DATEDIF(DATE(YEAR(A1)+(TEXT(A1,"mmdd")>"0405")-1,4,5),B1,"y")-1

To explicitly count "6th April" dates

=SUMPRODUCT((TEXT(ROW(INDIRECT(A1&":"&B1)),"mmdd")="0406")+0)

As you say the second will normally be one higher than the latter but presumably if you had these dates

A1 = 6th April 2007
B1 = 5th April 2008

then this would constitute 1 whole tax year.....but the range only contains 1 6th April.......

Note: If you have a non-English version of excel then TEXT function may need to be modified to your own language requirement, i.e. "mmdd" may need to be modified

Thank you so much Daddlonglegs; you are a star!!