# Year function

#### Raz

##### New Member
I need to set up a year counter alongside a set of dates. The year function does this but this gives me calendar year and I need Financial Year. Is there a function which will allow me to get financial year??

### 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
Raz,
Welcome to the board. This may help:

=IF(MONTH(\$B\$6)=12,"","F")&TEXT(DATE(YEAR(B10),MONTH(B10)+(12-MONTH(\$B\$6)),DAY(B10)),"yyyy")

where \$B\$6 has the date of your fiscal year end (ie, 3/31/01) and B10 has the date of a given period (ie 6/30/01). For example, these two data points should yield F2002.

Alriemer

You could use a Lookup formula or a formula.

=IF(MONTH(B10)>3,"F"&YEAR(B10)+1,"F"&YEAR(B10))

or ="F"&YEAR(B10)+LOOKUP(MONTH(B10),{1,4;0,1})

="F"&YEAR(B10)+(MONTH(B10)>3)&"-"&LOOKUP(MONTH(B10),{1,2,3,4,5,6,7,8,9,10,11,12;10,11,12,1,2,3,4,5,6,7,8,9})

or A Lookup table to accommodate special month-end dates
This message was edited by Dave Patton on 2002-10-08 19:03

Replies
2
Views
452
Replies
10
Views
411
Replies
9
Views
150
Replies
9
Views
327
Replies
1
Views
170

1,207,280
Messages
6,077,506
Members
446,287
Latest member
tjverdugo85

### 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