Calculating Tax Years from dates (UK)

UK tax year is based on 5 April.  So 5 April 2004 is in the 2003 tax year and 6 April 2004 is in the 2004 Tax year.  Can anyone help me with a formula to put dates into the correct tax year
Answer
Answer

=YEAR(A1)-(A1<=DATE(YEAR(A1),4,5))

This will only provide the tax year.

7 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 21, 2025 Views 3,009 Applies to: