| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Time Difference
Hi... I'm trying to calculate the total number of months difference between a
hire date and the current date (now()) but keep getting a "#VALUE" My employment date is in C2 and I need the result in C3, can anyone help? -- Thanks! -Jennifer |
|
#2
|
|||
|
|||
|
One way:
C2: =DATEDIF(C2,TODAY(),"m") See http://cpearson.com/excel/datedif.htm for documentation on DATEDIF. In article , "Jennifer" wrote: Hi... I'm trying to calculate the total number of months difference between a hire date and the current date (now()) but keep getting a "#VALUE" My employment date is in C2 and I need the result in C3, can anyone help? |
|
#3
|
|||
|
|||
|
Hi
=DATEDIF(A1,TODAY(),"m") -- Regards Frank Kabel Frankfurt, Germany Jennifer wrote: Hi... I'm trying to calculate the total number of months difference between a hire date and the current date (now()) but keep getting a "#VALUE" My employment date is in C2 and I need the result in C3, can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate the difference in time? | Excel Worksheet Functions | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
| Calculating time difference | Excel Discussion (Misc queries) | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Hybrid Mode
