ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 304
- Office Version
- 2016
- Platform
- Windows
I am trying to determine how many weeks are in a given Excel Quarter (Standard, not ISO)
I cannot just use 13 as there are some Quarters that are 14. Like this year.
The data I have to work with is the Year cell (A1), and the Quarter, cell (A2)
A1 = 2020
A2 = Q1
I cannot just use 13 as there are some Quarters that are 14. Like this year.
The data I have to work with is the Year cell (A1), and the Quarter, cell (A2)
A1 = 2020
A2 = Q1