Excel Formular help
 

I am trying to reference dates within a spreadshett that fall per fanancial
year and return it as a number representing the quarter of the year for which
it falls.

For eample if I have a date in column A
A B
12/27/2005
04/28/2005
07/28/2005
10/28/2005

In colume B I would like it to identify what part of the financial year
(between April to march. Therefore the B column for the above would show

B
Q4 05
Q1 05
Q3 05
Q3 05

Can any one help.






































12/27/2005 23:08:29 FLAT 3/5 FAIRFIELD AVENUE, OFF HIGH STREET,
STAINES S10 MECHANICAL MECH AFA DOM 503874171786 FLATS -1
12/28/2005 9:59:46 PAGE AEROSPACE, OFF FORGE LANE,
SUNBURY S19 MECHANICAL MECH AFA 510382168588 FACTORY/WORKSHOP -5
12/28/2005 12:31:32 25 GORDON ROAD, OFF STANWELL ROAD,
ASHFORD S10 FDR1 FDR1 506267172468 HOUSE/BUNGALOW -1
12/28/2005 15:24:25 37 THE PARADE, OFF SUNBURY CROSS, SUNBURY S19 SSC SSC
INCIDENT 509901170141 FLATS -1


--
pk

Excel Formular help
 

What is the the date of the first day of each quarter of 2005?
--
Gary''s Student - gsnu200752


"PK" wrote:

I am trying to reference dates within a spreadshett that fall per fanancial
year and return it as a number representing the quarter of the year for which
it falls.

For eample if I have a date in column A
A B
12/27/2005
04/28/2005
07/28/2005
10/28/2005

In colume B I would like it to identify what part of the financial year
(between April to march. Therefore the B column for the above would show

B
Q4 05
Q1 05
Q3 05
Q3 05

Can any one help.






































12/27/2005 23:08:29 FLAT 3/5 FAIRFIELD AVENUE, OFF HIGH STREET,
STAINES S10 MECHANICAL MECH AFA DOM 503874171786 FLATS -1
12/28/2005 9:59:46 PAGE AEROSPACE, OFF FORGE LANE,
SUNBURY S19 MECHANICAL MECH AFA 510382168588 FACTORY/WORKSHOP -5
12/28/2005 12:31:32 25 GORDON ROAD, OFF STANWELL ROAD,
ASHFORD S10 FDR1 FDR1 506267172468 HOUSE/BUNGALOW -1
12/28/2005 15:24:25 37 THE PARADE, OFF SUNBURY CROSS, SUNBURY S19 SSC SSC
INCIDENT 509901170141 FLATS -1


--
pk