View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sa2960 sa2960 is offline
external usenet poster
 
Posts: 2
Default Formula to determine Fiscal Year

I have the customers start date in Column A, i.e. 4/1/2007.
In Column B I would like to determine what fiscal year they started in.

For example:
If their start date is between 3/1/08 - 2/28/09, I would like the result of
Column B to be FY08/09.
If their start date is between 3/1/07 - 2/28/08, I would like the result of
Column B to be FY07/08.

Is there a formula for this?