Financial Year dates

tnolan

New Member
Joined
Jul 29, 2007
Messages
13
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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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 ...

<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook
ABCD
68-Jan-09
7
8
9
10FY10
11
Sheet7


</body></html>

I hope this helps.
 

tnolan

New Member
Joined
Jul 29, 2007
Messages
13
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
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi tnolan:

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

<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook
ABCD
5
61-Aug-09
7
8
9
10FY10
11
Sheet7


</body></html>
 

tnolan

New Member
Joined
Jul 29, 2007
Messages
13
I meant to say that
If I put in 1st May 2009 (01/05/09) - this should fall in FY08.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
57,262
Office Version
  1. 365
Platform
  1. Windows
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
 

Forum statistics

Threads
1,181,102
Messages
5,928,072
Members
436,586
Latest member
latintxn

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top