if function
Sorry, hit the button too soon.
The MONTH(A1)/3 takes the month of the given date, and divides by 3 to give
a value of .33,.66 or 1 for the first three months, 1.33, 1.66 or 2 for the
second 3 months, etc.
CEILING(val,1) takes it up to the nearest integer, 1,2, etc.
CHOOSE then uses that value to pick from the comma delimited list.
Example,
A1 contains 20th October
MONTH(A1) = 10
MONTH(A1)/3 = 3.33
CEILING(MONTH(A1)/3),1) = 4
CHOOSE then picks the 4th value, Q4
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Matt D Francis" wrote in message
...
Hi,
I've been looking for this for a while, thank-you! Could yo explain how it
works please/ I'm not familar with the CHOOSE and CEILING functions.
Matt
"Gary''s Student" wrote:
The quarters are easy. If the date is in A1 then:
=CHOOSE(CEILING(MONTH(A1)/3,1),"Q1","Q2","Q3","Q4")
will give the correct quarter.
Gary''s Student
|