Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 versus 2002 seem incompatible related to the EDATE fun.
I have a 2003 version of Excel. Others in the office have a 2002 version.
There is a date function used in the 2002 worksheets "EDATE" that is not recognized by my 2003 version and it has made the worksheet useless unless I work off an old version of EXCEL. That doesn't seem right??? One fix that I have attempted in to convert EDATE function to DATEVALUE function, but then rather than triggering off of months, I am having to build future dates off of the number of days between dates. That doesn't seem right either??? |
#2
|
|||
|
|||
The Edate function is available if you go to ToolsAdd-ins and load the
Analysis Toolpak. "MCLENO" wrote: I have a 2003 version of Excel. Others in the office have a 2002 version. There is a date function used in the 2002 worksheets "EDATE" that is not recognized by my 2003 version and it has made the worksheet useless unless I work off an old version of EXCEL. That doesn't seem right??? One fix that I have attempted in to convert EDATE function to DATEVALUE function, but then rather than triggering off of months, I am having to build future dates off of the number of days between dates. That doesn't seem right either??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where is text to speech in excel 2003? | Excel Discussion (Misc queries) | |||
Excel 2002 calcs slower than Excel 97 | Excel Discussion (Misc queries) | |||
LINEST bug with cubic polynomials in Excel 2003 | Excel Worksheet Functions | |||
Automatic links in Excel 2003 | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |