formula for date
Hi
I'm sure there is an easier way, but this works
="Q"&2+CEILING(MONTH(B1),3)/3-4*(MONTH(B1)6)
--
Regards
Roger Govier
"bee" wrote in message
...
The formulaes worked for a calendar year but from that post but I could
not
get it to work for the financial year. e.g 12/12/06 came up as q4 and I
needed it to come up as q2.
Thank you.
"Roger Govier" wrote:
Hi
You posted this question in worksheet functions on 6th Oct.
You had several answers then, including my response of
="Q"&CEILING(MONTH(B1),3)/3
Did they not work for you?
--
Regards
Roger Govier
"bee" wrote in message
...
i have two columns
col a col b
q3 2/2/07
q2 10/12/06
I have 4 quarters in a financial year jul-sep, oct-dec, jan-mar and
apr-jun
is there a formula I can enter in col a so that when I enter date in
col b
then correct quarter will come up in col a
Thank you for your assistance
|