Financial Year dates

T

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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
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
Click to expand...

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.
 
Upvote 0
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
 
Upvote 0
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>
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

U
  • Question
Week number based on the year starting with a particular date
Replies
2
Views
316
Jeffrey Mahoney
Jeffrey Mahoney
C
  • Question
Revenue Allocation by Week
Replies
3
Views
217
ChetanPuri
C
M
  • Solved
How to count certain month from a column
Replies
3
Views
91
Joe4
Joe4
J
  • Locked
  • Question
Excel Formula
Replies
1
Views
225
Joe4
Joe4
J
  • Question
Formula to change values in different cells - HELP!!
Replies
1
Views
277
awoohaw
awoohaw

Forum statistics

Threads
1,214,403
Messages
6,119,309
Members
448,886
Latest member
GBCTeacher

Share this page

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
Back
Top