Financial Year

Neil Watson

Hi, our financial year (FY) runs from July to June. I want to be able to determine from a row date, the relevant FY. Dates are in format dd/mm/yyyy

For example: any date between 1/7/2019 to 30/6/2020 will be FY19. Any date between 1/7/2021 to 30/6/2022 will be FY21. etc.

I would prefer not to "hard code" any dates in the formula, rather use the TODAY() function.

Bassam Khalil

Hi @Neil Watson

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Or if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

Neil Watson

@Bassam Khalil I sent you a link

Bassam Khalil

@Neil Watson

you sent the link to the summary sheet only, i can't create the formula with out the data source sheet.