Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EDATE Function
I have a worksheet that contains (3) columns of date information; Start Date,
Number of Months, End Date. To calculate the End Date, I am using the EDATE function that is not outputting the answer I am expecting. As an example of what EDATE reports, here are some examples. Start Date # of Months End Date Example 1 Nov-10 (16) May-09 Example 2 Nov-10 (12) Nov-09 Example 3 Nov-10 (18) May-10 Example 4 Nov-10 (18) Nov-10 Can anyone tell me why EDATE is reporting incorrect data and how I might be able to fix it? Your response would be appreciated. Thank You, JAD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EDate function + #NAME? error | Excel Worksheet Functions | |||
Edate function Name error | Excel Discussion (Misc queries) | |||
edate function | Excel Worksheet Functions | |||
EDate function doesn't work! | Excel Worksheet Functions | |||
edate function | Excel Worksheet Functions |