Hello,
I'm looking for a way to pull out quarter numbers and year from a date range, for example:
10/1/2023 - 2/1/2024 would return Q4 23, Q1 24
I've provided an example file for reference, thank you very much
Josh
Formula/VBA to obtain quarters in a date range
-
- 2StarLounger
- Posts: 120
- Joined: 16 Oct 2021, 16:22
Formula/VBA to obtain quarters in a date range
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 80088
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formula/VBA to obtain quarters in a date range
If you have Microsoft 365, Office 2021 or Office 2024, see the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 120
- Joined: 16 Oct 2021, 16:22
Re: Formula/VBA to obtain quarters in a date range
You're amazing Hans as always, thank you