gls858

Posts: n/a

Formula to fill inthe Quarter

I seem to always have trouble when dealing with dates in Excel.
Is it possible to have a formula the would look at the date field
and fill in the quarter in col 1? Dates 01/01/02 - 03/31/02 = Qtr1
and so forth.

Sample data:
A B C
Qtr Invoice Date
325938-0 1/2/2002
326529-0 1/4/2002
326910-1 1/7/2002
326942-0 1/7/2002
C 324534-0 1/9/2002
328088-0 1/10/2002

gls858

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
formula will not fill correctly due to odd number rows	Barb	Excel Worksheet Functions	3	May 10th 05 09:10 PM
Fill formula question	Meredith	Excel Worksheet Functions	1	March 29th 05 11:19 AM
Possible? formula in one cell can fill another cell	Sherri	Excel Worksheet Functions	3	March 24th 05 12:35 AM
Formula to count the cells in a range that have a fill color.	Slainteva	Excel Discussion (Misc queries)	2	January 19th 05 08:25 PM
Formula to count the cells in a range that have a fill color.	Molly F	Excel Discussion (Misc queries)	2	January 19th 05 06:15 PM

All times are GMT +1. The time now is 08:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us