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