💻 Software
How can I obtain the year quarter from a date?
Fresh5 days ago
Mar 15, 202650454 viewsConfidence Score0%
0%
Problem
In Excel, how can I obtain the year quarter from a date, using a worksheet formula? I have a column with dates spanning multiple years. Jan-01 to Mar-31 = Q1 Apr-01 to June-30 = Q2 etc... Bonus question: How can I shift the quarter so Q1 is April-June (Jan-Mar would be Q4).
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can I obtain the year quarter from a date?
Low Risk
Depending on how you have formatted your Date value, excel may automatically covert it to the "date code". this is the number of days since Jan 1, 1900 (Date code of 1). This number is then used by the different Date functions. Here is a suggested f…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix