Posted to microsoft.public.excel.misc

harsh_njoy harsh_njoy is offline

external usenet poster

Posts: 4

Identifying quarter to which a date belongs?

how to identify the quarter to which the following date belongs
'31/3/2007' in excel?

please let me know what function i should apply on the cell to get the
quarter. like in the above case answer comes out to be - 1.

Thanks,
Harsh

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Date To Quarter, Plus Next 3 Quarters	Bob	Excel Worksheet Functions	1	November 3rd 06 12:25 PM
Quarter End Date	[email protected]	Excel Worksheet Functions	6	April 6th 06 06:54 PM
Format to display date as Quarter	Christine	Excel Discussion (Misc queries)	5	October 19th 05 03:30 AM
Date formula: return Quarter and Fiscal Year of a date	Rob	Excel Discussion (Misc queries)	7	May 11th 05 08:48 PM
Identifying Date Overlaps	Tremain	Excel Discussion (Misc queries)	1	May 10th 05 01:58 AM

All times are GMT +1. The time now is 05:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us