# Financial Year Dates Calculations

#### tazeo

##### Board Regular
Here in Australia the financial year runs Start of July through to End of June.

If I have A1 =TODAY()
How do I get values for cells looking for:
Start of this Fin Year
End of this Fin Year
Start of Last Fin Year
End of Last Fin Year

Referenceing of what the date is Today or at any time in the future.

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### SydneyGeek

##### MrExcel MVP
For Start This FY, =IF(MONTH(A1)>6,DATE(YEAR(A1),7,1),DATE(YEAR(A1)-1,7,1))

For End This FY, =IF(MONTH(A1)>6,DATE(YEAR(A1)+1,6,30),DATE(YEAR(A1),6,30))

Adjust the Year component up or down for next FY and last FY.

Denis

#### tazeo

##### Board Regular
Thanks Denis
I always forget the DATE function

#### Boller

##### Banned
Start TY =DATE(YEAR(A1)-(MONTH(A1)<7),7,1)
End TY =DATE(YEAR(A1)+1-(MONTH(A1)<7),7,0)
Start LY =DATE(YEAR(A1)-(MONTH(A1)<7)-1,7,1)
End LY =DATE(YEAR(A1)-(MONTH(A1)<7),7,0)

It's probably advisable to Name the formulas for easier identification.

#### tazeo

##### Board Regular
Thanks as well Boller

Replies
4
Views
213
Replies
7
Views
249
Replies
7
Views
148
Replies
8
Views
180
Replies
2
Views
104

1,127,722
Messages
5,626,497
Members
416,187
Latest member
L_D18

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