🚀 go-pugleaf

In article <1e711oINNi8h@lester.appstate.edu>, WHITESR@CONRAD.APPSTATE.EDU (*Steve White         ) writes:
|> 
|> I have a series of dates in cells within an Excel 3.0 sheet.
|> 
|> What's the easiest way to display those dates as quarters?
|> 
|> For example, I would want dates 1/1 through 3/30 displayed
|> something like "Q1", 4/1 through 6/30 displayed something
|> like "Q2", etc.
|> 

Try something like this (off the top of my head... ==untested!)

  =choose(month(<datevalue reference>),"Q1","Q1","Q1","Q2","Q2","Q2",.. etc)

assuming the <datevalue reference> is a cell were the dates are entered as
a datevalue  (hmmm.. that sure sounds like doubletalk to me..)

Place this formula in a row and then set the row height on the row containing
the original datevalue info to 0.

Hope this works...

-- 
 ----------------------------------------------------------------------------
 Tim Tow                              |                                      
 Intergraph Corporation               | "Injustice anywhere is a             
 Huntsville, AL                       |      threat to justice everywhere"    
 Mailpath:..timtow@timtow.b1.ingr.com |                                      
 Voice:                  205-730-2117 |         - Dr Martin Luther King, Jr
 ----------------------------------------------------------------------------

> For example, I would want dates 1/1 through 3/30 displayed
> something like "Q1", 4/1 through 6/30 displayed something
> like "Q2", etc.
> 
> Can this be done through the Format-Number command? Or do
> I need to convert the dates through cumbersome formulae
> with "IF" statement(s)?

As far as I know, no you can't accomplish this with the format number
command on its own.  But by the same token, you do not need to use IF
statements.
Say your date is in cell A1, then one possible formula is:
     ="Q"&TEXT(INT(MONTH(A1)/4)+1,"0")

This is about the easiest way which readily springs to mind, but of
course there may well be others.

Regards,
Justin Ridge
University of Tasmania


--