Article View: comp.apps.spreadsheets
Article #265Re: Displaying quarters in Excel?
From: Justin Ridge
Date: Tue, 17 Nov 1992 05:00
Date: Tue, 17 Nov 1992 05:00
24 lines
1198 bytes
1198 bytes
> 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
--
Technical Details
Message-ID:
<justin.721976443@tasman>Path:
arc1-ca.pugleaf.net!sparky!uunet!usc!zaphod.mps.ohio-state.edu!rpi!batcomputer!munnari.oz.au!newsroom.utas.edu.au!tasman.cc.utas.edu.au!justinReferences:
<1e711oINNi8h@lester.appstate.edu>Show Full Headers
Complete Article Headers
Newsgroups: comp.apps.spreadsheets Path: arc1-ca.pugleaf.net!sparky!uunet!usc!zaphod.mps.ohio-state.edu!rpi!batcomputer!munnari.oz.au!newsroom.utas.edu.au!tasman.cc.utas.edu.au!justin From: justin@tasman.cc.utas.edu.au (Justin Ridge) Subject: Re: Displaying quarters in Excel? Message-ID: <justin.721976443@tasman> Sender: news@newsroom.utas.edu.au Organization: University of Tasmania, Australia. References: <1e711oINNi8h@lester.appstate.edu> Date: Tue, 17 Nov 1992 05:00:43 GMT Lines: 24