QUARTER
Gets the calendar quarter for the specified date. For more details see Quarters.
Syntax
=QUARTER(date)
Arguments
| Argument | Type | Description |
|---|---|---|
| date | Date | The date to use for calculation |
Examples
=QUARTER(DATE(2020, 2, 3, 4, 5))→1
Gets the quarter component 1 from the specified date Feb 3, 2020 4:05 AM
=QUARTER(DATE(2020, 4, 5, 6, 7))→2
Gets the quarter component 2 from the specified date Apr 5, 2020 6:07 AM
Updated 10 months ago