# Financial Year dates

#### tnolan

##### New Member
Hi,

I enter a date in cell B6 but I want cell d10 to show which Financial year it falls in

ie B6 = 01/08/2009
D10 should show text FY10

If I change B6 to 01/08/2010 then D10 should update to FY11

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Hi,

I enter a date in cell B6 but I want cell d10 to show which Financial year it falls in

ie B6 = 01/08/2009
D10 should show text FY10

If I change B6 to 01/08/2010 then D10 should update to FY11

Hi tnolan:

Welcome to MrExcel Board!

Let us look at ...

Excel Workbook
ABCD
68-Jan-09
7
8
9
10FY10
11
Sheet7

</body></html>

I hope this helps.

Hi,

that date should be 1st Aug 2009 (01/08/09) which falls in FY10.

If I put in 1st May 2009 (01/05/09) - this should fall in FY09.

Financial years are from 01 Jul to 30 June

What i am trying to say is - if the date is between 01/07/08 and 30/06/09 then put FY09 in the relevant cell

Hi tnolan:

Thanks for the clarification ... that helps. So, her we go ...

Excel Workbook
ABCD
5
61-Aug-09
7
8
9
10FY10
11
Sheet7

</body></html>

I meant to say that
If I put in 1st May 2009 (01/05/09) - this should fall in FY08.

tnolan

Welcome to the MrExcel board!

Your messages about what dates fall in what FY are confusing. However, you should be able to adjust this by changing the "6" in the EDATE formula if it does not already do what you want.

Note that you need to have Analysis Toolpak installed and enabled for the EDATE function to work. Check in Tools|Add-Ins...

Just copy the B2 formula down.

Excel Workbook
AB
1DateFY
215/12/2005FY06
315/01/2006FY06
415/02/2006FY06
515/03/2006FY06
615/04/2006FY06
715/05/2006FY06
815/06/2006FY06
915/07/2006FY07
1015/08/2006FY07
1115/09/2006FY07
1215/10/2006FY07
1315/11/2006FY07
1415/12/2006FY07
1515/01/2007FY07
FY

perfect, thanks Peter

Replies
4
Views
681
Replies
2
Views
325
Replies
2
Views
780
Replies
3
Views
524
Replies
8
Views
417

1,219,914
Messages
6,150,937
Members
450,995
Latest member
LBlke

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back