home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.apps.spreadsheets
- Path: sparky!uunet!infonode!timtow.b1.ingr.com!timtow
- From: timtow@timtow.b1.ingr.com (Tim Tow)
- Subject: Re: Displaying quarters in Excel?
- Message-ID: <1992Nov16.150650.6856@infonode.ingr.com>
- Sender: usenet@infonode.ingr.com (Usenet Administrator)
- Reply-To: timtow@timtow.b1.ingr.com
- Organization: Intergraph Corp, Huntsville, Alabama
- References: <1e711oINNi8h@lester.appstate.edu>
- Date: Mon, 16 Nov 1992 15:06:50 GMT
- Lines: 31
-
- 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
- ----------------------------------------------------------------------------
-