How to return a Tax Year

[PeterA]

Hi

Does anyone know how to create a formula to retunr the tax year for a date, for example if the date was 12/09/1995 the tax year would be 06/04/1995 or if it were 11/01/1997 the tax year would be 06/04/1996.

Kind regards

Peter

[pjwhitfield]

Please Login or Register  to view this content.

[boopathiraja]

Hi, try

Please Login or Register  to view this content.

[PeterA]

Wow thanks for the incredibly fast response.

For anyone else who looks at this I did need to make some changes

=IF(DATE(YEAR(B4),4,6)<=B4,DATE(YEAR(B4),4,6),DATE(YEAR(B4)-1,4,6))

Thanks

Peter

[pjwhitfield]

Duh, not sure where my brain was there, I amended the code to show A1 rather than the random cell Id written it against then forgot to change one reference....not sure how I didnt spot the -/+ issue though?!?!? </SchoolboyError>