| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting a date in Excel 2002 to a Year/Quarter format
Is there a formula or function that I can use in Excel 2002 to convert a date
to a year/quarter format. For instance if the date said 2/35/2005, I would like to represent that as 2005Q1 or Q12005, something like that. If someone has an idea, please share it. Thanks. |
|
#2
|
|||
|
|||
|
Hi,
There isn't a format that does this, but try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3) Regards, David Jessop "Jim" wrote: Is there a formula or function that I can use in Excel 2002 to convert a date to a year/quarter format. For instance if the date said 2/35/2005, I would like to represent that as 2005Q1 or Q12005, something like that. If someone has an idea, please share it. Thanks. |
|
#3
|
|||
|
|||
|
I tried your syntax below and it worked perfectly David! Thank you very much
for your help and quick response! "David Jessop" wrote: Hi, There isn't a format that does this, but try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3) Regards, David Jessop "Jim" wrote: Is there a formula or function that I can use in Excel 2002 to convert a date to a year/quarter format. For instance if the date said 2/35/2005, I would like to represent that as 2005Q1 or Q12005, something like that. If someone has an idea, please share it. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Default date for date format | Excel Discussion (Misc queries) | |||
| Converting numbers to date format from csv files | Excel Discussion (Misc queries) | |||
| Excel 2002 date formulas problem | Excel Worksheet Functions | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Linear Mode
