Words to numbers

  • Thread starter Thread starter Anonimus Secret Gates
  • Start date 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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate number of months 2
Expanding Date formula 1
converting numbers to months 7
calculate number of months based on one date 1
count total dates for each month 2
About calculate months between two date (date function) 2
XL calculation formula 4
Converting numbers 5

Back
Top