I need to comeup with an IF statement, where of a date is moving from one financial year to another, the output is Y.

I have tried working it out bu working with the financial year as oppossed to the calander year is causing me problems.

Appreciate you help.

Please email me at ray.everingham@housingcorp.gsx.gov.uk