| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datedif using cell references Excel 2000
I'm using Excel 2000 and trying to use the datedif function. I've formated 2
columns as date m/dd/yyyy and left the formula column general I'm entering dates A1: 1/1/2002 B1: 1/1/2005 I'm entering the formula in C1 =datedif(b1,a1,"M") I'm looking for the nmber of months between 2 dates I get #NUM! for a result. Thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Reference's when Pasting | Excel Discussion (Misc queries) | |||
| Multiple or Variable cell references in Solver (Excel 97) | Excel Worksheet Functions | |||
| Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
