ExcelBanter - Formula for Calendar Quarter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula for Calendar Quarter (https://www.excelbanter.com/excel-worksheet-functions/102868-formula-calendar-quarter.html)

Robert

Formula for Calendar Quarter

What is the formula to indicate the quarter for a given date (say in cell A1)
e.g. 25-Apr-06 = 2, 4-Jul-06 = 3, 1-Oct-06 = 4.
Thank you
--
Robert

N Harkawat

Formula for Calendar Quarter

=roundup(month(a1)/3,0)

"Robert" wrote in message
...
What is the formula to indicate the quarter for a given date (say in cell
A1)
e.g. 25-Apr-06 = 2, 4-Jul-06 = 3, 1-Oct-06 = 4.
Thank you
--
Robert

Robert

Formula for Calendar Quarter

Thank you Harkawat.
--
Robert

All times are GMT +1. The time now is 12:58 PM.