Fiscal year - calendar year - help and advice, please|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi

I have come across a problem this naming my data files and wondered anyone had a solution or could help.

Our business year and our tax year begin in April. So for our first month I used the 2024_04 for the data file name then carried on adding another file for each month. The problem will be when we get to January 2025...it will still be in the fiscal (and our) year but if I use the file suffix 2024_01 that will look like last January; if I use 2025_01 it will look like it might be in fiscal 2025-2026.

Anything you can suggest? Do you know what other companies do?

Thank you in advance

Kind regards

Chris