Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Calendar Quarter
Thank you Harkawat.
-- Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking portions of a formula | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel |