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

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?

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?