Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Christine
 
Posts: n/a
Default 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   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default 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   Report Post  
Christine
 
Posts: n/a
Default 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   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default 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   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default 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   Report Post  
Christine
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format date in excel Nigel Excel Discussion (Misc queries) 2 September 15th 05 09:52 PM
Why Does Date Format Change on Chart John Taylor Excel Discussion (Misc queries) 0 September 11th 05 08:16 AM
Help needed with date format [email protected] Excel Discussion (Misc queries) 1 August 29th 05 09:11 AM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
How to format a date to a different format Laura Excel Discussion (Misc queries) 1 March 5th 05 10:59 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"