Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
quarter
How to display what quarter a date falls in?
03/24/2009 = "Q1" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
quarter
Hi,
Use this formula. I have assumed that the date is in cell C6. ="Q"&IF(MOD(MONTH(C6),3)=0,MONTH(C6)/3,INT(MONTH(C6)/3)+1) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kent Prokopy" <kent wrote in message ... How to display what quarter a date falls in? 03/24/2009 = "Q1" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
quarter
Try
=ROUNDUP(MONTH(A1)/3,0) Mike "Kent Prokopy" wrote: How to display what quarter a date falls in? 03/24/2009 = "Q1" |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
quarter
If you want the Q to display
="Q"&ROUNDUP(MONTH(A1)/3,0) Mike "Mike H" wrote: Try =ROUNDUP(MONTH(A1)/3,0) Mike "Kent Prokopy" wrote: How to display what quarter a date falls in? 03/24/2009 = "Q1" |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
quarter
="Q"&INT((MONTH(A1)+2)/3)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
quarter report | Excel Discussion (Misc queries) | |||
sumproduct by quarter | Excel Discussion (Misc queries) | |||
I want to round Int to quarter | Excel Worksheet Functions | |||
Quarter End Date | Excel Worksheet Functions | |||
First and Last Day of the Quarter | Excel Worksheet Functions |