Words to numbers

  • Thread starter Anonimus Secret Gates
  • Start date
A

Anonimus Secret Gates

guys i need to know how to calculate how many months have pass from a date
to january of 2006
Ej. Dic-79 (12/1979, in this case are 313 months)

if you know how (you almost always know) please let me know
thanks and happy new year
 
G

Gary''s Student

With a true date in A1:

=DATEDIF(A1,DATE(2006,1,1),"m")

for example, if A1 contains 1/18/1945, then the formula gives 731
 
Top