=YEAR(DATE(YEAR(A1),MONTH(A1)-3,1))


or with fewer function calls:


=YEAR(A1)-(MONTH(A1)<4)
--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"JE McGimpsey" wrote in message
...
one way:

instead of

=YEAR(A1)

use


In article ,
"Martin_London" wrote:

In the UK our financial year runs April to March. Is there any way of
using
the =year() function on a date so that it runs on these dates rather than
calender years? Basically I need Jan, Feb and March of next year to be
recognised as the same year as April to December of this year.