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

Changing dates to a fiscal year
 

What is the 7/1/8 and 7/1/7 that you are testing G11 supposed to be...
dates??? Excel is seeing them a set of divisions (7 divided by 1 and that
result divided by 8 or 7 depending on which test we are talking about.

--
Rick (MVP - Excel)


"Twodot" wrote in message
...
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

Changing dates to a fiscal year
 

Hello:

Excel things your dates are text so it will not compare. Use the following:
=IF(G11=DATEVALUE("07/01/08"),"FY09",IF(G11=DATEVALUE("07/01/07"),"FY08","PRIOR"))

Monika

"Twodot" wrote:

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

Changing dates to a fiscal year
 

=LOOKUP(G11,{0,39264,39630},{"PRIOR","FY08","FY09" })


"Twodot" wrote:

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