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