Date analysis

[EvansB2]

Hi there,

I have long list of Dates as shown in column A below. In column B I want to return the Financial Period to which the date relates. The Financial Period is April to March each year, therefore, I have manually input the correct results in cells B2 & B3. Can a formula be written to speed this up based on this criteria?

Any help would be very welcome.

Ben

	A	B
1	Date	Period
2	03/02/2010	2009-10
3	04/08/2010	2010-11
4
5
6
7

<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;"> <tbody> </tbody>

 

[RoryA]

For a date in A2, you might use:

=YEAR(A2)-(MONTH(A2)<4)&"-"&YEAR(A2)+(MONTH(A2)>3)

 

[EvansB2]

Apologies for the late reply, I've just realised that I need to update my email address after nearly 10 years with the original one!

I will give it a go!

Ben