home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #27 / NN_1992_27.iso / spool / comp / apps / spreadsh / 656 < prev    next >
Encoding:
Text File  |  1992-11-16  |  1.8 KB  |  44 lines

  1. Newsgroups: comp.apps.spreadsheets
  2. Path: sparky!uunet!infonode!timtow.b1.ingr.com!timtow
  3. From: timtow@timtow.b1.ingr.com (Tim Tow)
  4. Subject: Re: Displaying quarters in Excel?
  5. Message-ID: <1992Nov16.150650.6856@infonode.ingr.com>
  6. Sender: usenet@infonode.ingr.com (Usenet Administrator)
  7. Reply-To: timtow@timtow.b1.ingr.com
  8. Organization: Intergraph Corp, Huntsville, Alabama
  9. References:  <1e711oINNi8h@lester.appstate.edu>
  10. Date: Mon, 16 Nov 1992 15:06:50 GMT
  11. Lines: 31
  12.  
  13. In article <1e711oINNi8h@lester.appstate.edu>, WHITESR@CONRAD.APPSTATE.EDU (*Steve White         ) writes:
  14. |> 
  15. |> I have a series of dates in cells within an Excel 3.0 sheet.
  16. |> 
  17. |> What's the easiest way to display those dates as quarters?
  18. |> 
  19. |> For example, I would want dates 1/1 through 3/30 displayed
  20. |> something like "Q1", 4/1 through 6/30 displayed something
  21. |> like "Q2", etc.
  22. |> 
  23.  
  24. Try something like this (off the top of my head... ==untested!)
  25.  
  26.   =choose(month(<datevalue reference>),"Q1","Q1","Q1","Q2","Q2","Q2",.. etc)
  27.  
  28. assuming the <datevalue reference> is a cell were the dates are entered as
  29. a datevalue  (hmmm.. that sure sounds like doubletalk to me..)
  30.  
  31. Place this formula in a row and then set the row height on the row containing
  32. the original datevalue info to 0.
  33.  
  34. Hope this works...
  35.  
  36. -- 
  37.  ----------------------------------------------------------------------------
  38.  Tim Tow                              |                                      
  39.  Intergraph Corporation               | "Injustice anywhere is a             
  40.  Huntsville, AL                       |      threat to justice everywhere"    
  41.  Mailpath:..timtow@timtow.b1.ingr.com |                                      
  42.  Voice:                  205-730-2117 |         - Dr Martin Luther King, Jr
  43.  ----------------------------------------------------------------------------
  44.