Fiscal year calsulations for past to future dates.
Please!
"Gary''s Student" wrote:
Do you want the first day in the fiscal year to be July 1st??
--
Gary''s Student - gsnu200843
"Nikki" wrote:
A date entered in A1 for example is 8/12/2004 that would be fiscal year 2005,
I am looking for a formula that will auto calculate what the correct fiscal
year is based on the date given and put it in B1. I need to go back to 2001
and would like to go as far forward as 2015.
|