Formula/VBA to obtain quarters in a date range

JDeMaro22
2StarLounger
Posts: 120
Joined: 16 Oct 2021, 16:22

Formula/VBA to obtain quarters in a date range

Post by JDeMaro22 »

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
Example.xlsx
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
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

Post by HansV »

If you have Microsoft 365, Office 2021 or Office 2024, see the attached version.

Example.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

JDeMaro22
2StarLounger
Posts: 120
Joined: 16 Oct 2021, 16:22

Re: Formula/VBA to obtain quarters in a date range

Post by JDeMaro22 »

You're amazing Hans as always, thank you