Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fiscal year calsulations for past to future dates. | Excel Discussion (Misc queries) | |||
Calculating Dates Within Fiscal Year | Excel Discussion (Misc queries) | |||
Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
Pivot Table: Change dates to fiscal year | Excel Worksheet Functions | |||
Pivot Table: Change dates to fiscal year | Excel Discussion (Misc queries) |