How to Set Up Financial Year Dates That Don’t Follow the Calendar Year?

Answers
-
Hi Brett,
Will this work for financial years that are not calendar years?
We have:
Start 01/02/25
End 31/01/26
I've used
Start =DATE(YEAR(TODAY()), 2, 1)
End =DATE(YEAR(TODAY()) + 1, 1, 31) (Just added a year to the current year)
I'm thinking that this will not work for our fin year, I've tested it with:
Date Test Col
Test - Date Today
01/01/25
Financial Year Start
Feb 1, 2025
Financial Year End
Jan 31, 2026
Financial Year Start =DATE(YEAR([Date Test]5), 2, 1)
Financial Year End =DATE((YEAR([Date Test]5) + 1), 1, 31)
Cheers in advance
-
@A_C What exactly are you hoping to accomplish?
-
Hi Paul,
I've got an expenses system for approx 30 people.
One of the components is the Expenses Configuration sheet. Sounds a bit grand but it is basically used for, holding / linking departments, managers and approvers etc.
I want to add the Fin Start and Fin End dates to this sheet, so I can link them to the individual expense trackers for each member of staff, so it updates all the sheets, and makes it easier to setup for new starters. This will then be used for calcs, relating to this year / last year etc. I want the financial year to update each year automatically.
Cheers,
A
-
Ok. That's high level, but what are you hoping to accomplish exactly with the formula(s)? It looks like you are trying to manipulate a date based on today's date, but how exactly?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!