Calculate Fiscal Year Date

[anillinda]

I have a cell a1 with date say "07/31/2016", I need to populate cell b2 with a date that can calculate fiscal year, when the fiscal year is not same as calendar year.
The fiscal year runs from 08/1/20xx to 07/31/20xx+1,
For example:
for date 07/15/2016 the fiscal year should end on 07/31/2016
for date 08/1/2015 the fiscal year end date should be 07/31/2016
for date 05/12/2015 the fiscal year should end on 07/31/2015
for date 08/15/2015 the fiscal year should end on 07/31/2016.

What formula can I use when the date in cell a1 can be different for each cell?

 

[Joe4]

For a date in cell A1, the formula would look like:

=DATE(IF(MONTH(A1)>7,YEAR(A1)+1,YEAR(A1)),7,31)