Thread: Changing dates to a fiscal year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TwoDot TwoDot is offline
external usenet poster
  
Posts: 5
Default Changing dates to a fiscal year
I am evaluating a column of dates and trying to assign each to a fiscal year.
I can't figure out what's wrong with this statement but it returns FY09 no
matter what date it is evaluating.

=IF(G11=7/1/8,"FY09",IF(G11=7/1/7,"FY08","PRIOR"))
--
twodots left
Reply With QuoteReply With Quote