🚀 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
 ----------------------------------------------------------------------------