Displaying quarters in Excel?

Article View: comp.apps.spreadsheets

Article #262

Back to comp.apps.spreadsheets Previous Next

#262

From: *Steve White
Date: Mon, 16 Nov 1992 02:29

18 lines
1143 bytes

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.

Can this be done through the Format-Number command? Or do
I need to convert the dates through cumbersome formulae
with "IF" statement(s)?

Thx much,
Steve
--------------------------------------------------------------------------
stephen r. white -- whitesr@appstate.bitnet -- whitesr@conrad.appstate.edu
--------------------------------------------------------------------------

Technical Details

Message-ID: <1e711oINNi8h@lester.appstate.edu>

Path:

arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!darwin.sura.net!uvaarpa!concert!lester.appstate.edu!lester.appstate.edu!usenet

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!darwin.sura.net!uvaarpa!concert!lester.appstate.edu!lester.appstate.edu!usenet
From: WHITESR@CONRAD.APPSTATE.EDU (*Steve White         )
Newsgroups: comp.apps.spreadsheets
Subject: Displaying quarters in Excel?
Date: 16 Nov 1992 02:29:12 GMT
Organization: APPALACHIAN STATE UNIVERSITY
Lines: 18
Distribution: world
Message-ID: <1e711oINNi8h@lester.appstate.edu>
NNTP-Posting-Host: conrad.appstate.edu
X-News-Reader: VMS NEWS 1.24