DATE Functions???

[malay_ko]

how will i classify the dates according to its quarter. lets say
10-02-03 (october 2, 2003) is it under 1st quarter, 2nd quarter, 3r
quarter,4th quarter of the year? what date function should i use? o
what do i have to do? pls help me with this. than

 

[Norman Harker]

Hi malay_ko!

We can use an easily adaptable formula:



=CHOOSE(MONTH(A1),1,1,1,2,2,2,3,3,3,4,4,4)



It should be clear that all you need to do is assign arguments 1,2,3 and 4
to all of the months in turn. At present the formula puts Jan, Feb. Mar into
Q1, Apr, May, Jun in Q2 etc.



So if you want Q1 to start in Oct use:



=CHOOSE(MONTH(A1),4,4,4,1,1,1,2,2,2,3,3,3)




--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

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