Format to display date as Quarter

C

Christine

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.
 
R

Ron Rosenfeld

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.
Click to expand...

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
 
C

Christine

That will do me! Thanks, Ron.

Ron Rosenfeld said:
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
Click to expand...
 
R

Ron Rosenfeld

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
Click to expand...

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
 
Top