View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default Fiscal year calsulations for past to future dates.

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.