| 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 |
| 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) | |||
Threaded Mode
