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.

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

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

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

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

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