Posted to microsoft.public.excel.worksheet.functions

Mike H

external usenet poster

Posts: 11,501

quarter

If you want the Q to display

="Q"&ROUNDUP(MONTH(A1)/3,0)

Mike

"Mike H" wrote:

Try

=ROUNDUP(MONTH(A1)/3,0)

Mike

"Kent Prokopy" wrote:

How to display what quarter a date falls in?

03/24/2009 = "Q1"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
quarter report	Shiva	Excel Discussion (Misc queries)	8	July 13th 08 08:46 PM
sumproduct by quarter	Brian	Excel Discussion (Misc queries)	4	December 3rd 07 07:30 PM
I want to round Int to quarter	QUESTION-MARK	Excel Worksheet Functions	3	January 8th 07 07:20 PM
Quarter End Date	[email protected]	Excel Worksheet Functions	6	April 6th 06 06:54 PM
First and Last Day of the Quarter	Wolfspaw	Excel Worksheet Functions	6	March 4th 06 02:10 AM

All times are GMT +1. The time now is 09:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us