Display UK Financial Year & Quarters
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
I hope I can get some solution as to how to display UK Financial Year and Quarters.
For my UK Financial Years starts from 1st Apr and ends 31st Mar.
I need to be able to display a new column indicating which UK FY a specific date falls into.
Eg, please see image of how I would like to be able to identify a specific date from a lengthy spreadsheet to indicate my UK FY and Quarters to display it as FY 2022-23 and FY 2022-23 Q1 etc..
Huge thanks in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hiya @ShankerV
Thanks for speedy response, really appreciate it.
This is brilliant and what exactly I need, however, I omitted to mentioned that in my image above where its states "FY written as" this is missing field is in my dataset.
Everything else you've outlined would work except for that bit, its like we'd need to take a step back and put in some formula to change/ input into Column B the appropriate FY 2022-23 or FY 2023-24 etc. based on whatever the date is written in Column A.
For my finalised data output I need to have both Columns B and C available to perform analysis.
Is that possible?
Your help would be appreciated if something like that can happened without it being cumbersome.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear @ShankerV
A gigantic thank you for helping us out with this - it works amazingly perfect for my needs at present. Was hunting high/low for such info on here but most of the result was based on US FY. Thanks again and have a great day. Regards,
