Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format to display date as Quarter
The solution could be simple but since I haven't found anything on it, it
probably isn't: The date can be formated to display in all different shapes. What I would like to do is not to display a "literal" version, e.g. the month, but the Quarter. As an example, 12/12/05 should display as QIV. Grateful for any help and suggestions! Thanks. |
#2
|
|||
|
|||
Format to display date as Quarter
On Tue, 18 Oct 2005 17:45:01 -0700, Christine
wrote: The solution could be simple but since I haven't found anything on it, it probably isn't: The date can be formated to display in all different shapes. What I would like to do is not to display a "literal" version, e.g. the month, but the Quarter. As an example, 12/12/05 should display as QIV. Grateful for any help and suggestions! Thanks. It is not possible to display Roman numerals using formatting. It is also not possible to display a date quarter using formatting. In both cases, you would need to have a text string. You could use this formula, though: ="Q"&ROMAN(CEILING(MONTH(dt)/3,1)) where dt refers to the cell where your date is stored. --ron |
#3
|
|||
|
|||
Format to display date as Quarter
That will do me! Thanks, Ron. "Ron Rosenfeld" wrote: On Tue, 18 Oct 2005 17:45:01 -0700, Christine wrote: The solution could be simple but since I haven't found anything on it, it probably isn't: The date can be formated to display in all different shapes. What I would like to do is not to display a "literal" version, e.g. the month, but the Quarter. As an example, 12/12/05 should display as QIV. Grateful for any help and suggestions! Thanks. It is not possible to display Roman numerals using formatting. It is also not possible to display a date quarter using formatting. In both cases, you would need to have a text string. You could use this formula, though: ="Q"&ROMAN(CEILING(MONTH(dt)/3,1)) where dt refers to the cell where your date is stored. --ron |
#4
|
|||
|
|||
Format to display date as Quarter
On Tue, 18 Oct 2005 21:23:05 -0400, Ron Rosenfeld
wrote: On Tue, 18 Oct 2005 17:45:01 -0700, Christine wrote: The solution could be simple but since I haven't found anything on it, it probably isn't: The date can be formated to display in all different shapes. What I would like to do is not to display a "literal" version, e.g. the month, but the Quarter. As an example, 12/12/05 should display as QIV. Grateful for any help and suggestions! Thanks. It is not possible to display Roman numerals using formatting. It is also not possible to display a date quarter using formatting. In both cases, you would need to have a text string. You could use this formula, though: ="Q"&ROMAN(CEILING(MONTH(dt)/3,1)) where dt refers to the cell where your date is stored. --ron A correction -- you could display the Quarter as a number; for example: =CEILING(MONTH(dt)/3,1) and format as (Format/Cells/Number/Custom Type:) \Q0 --ron |
#5
|
|||
|
|||
Format to display date as Quarter
On Tue, 18 Oct 2005 18:31:04 -0700, Christine
wrote: That will do me! Thanks, Ron. You're welcome. Glad to help. --ron |
#6
|
|||
|
|||
Format to display date as Quarter
I'll hang on to that as well ... Thanks!
A correction -- you could display the Quarter as a number; for example: =CEILING(MONTH(dt)/3,1) and format as (Format/Cells/Number/Custom Type:) \Q0 --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format date in excel | Excel Discussion (Misc queries) | |||
Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
Help needed with date format | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
How to format a date to a different format | Excel Discussion (Misc queries) |