Count months between 2 dates

I have a HP schedule and I want to count the months between todays date and the month the asset was purchased and I would like it to update each time I open the file

I have attached the file

Thanks
recycleausAsked:
Who is Participating?
 
ltswebConnect With a Mentor Commented:
I didn't see an attachment.  Would this work for you:

today      Date Aquired      Days      Months      rounded
3/21/2012      2/21/2010      759.00      25.3      25
=today()      enter date      =+E4-F4      =+G4/30      =ROUND(D2,0)

1st line is header
2nd line is data
3rd line is the formula I used


To put today's date in excel is =today()
I used /30 to calculate months (do you need to know actual months?)

If you need exact months, attach your spreadsheet.

Regards!
0
 
wchhCommented:
Another option:
=DATEDIF(A3,TODAY(),"m")
0
 
ltswebCommented:
WCHH, That is a good one too.
0
 
recycleausAuthor Commented:
Yeh WCHH solution was good but I needed the months rounded up which is what the first solution was able to do

thanks to you both... i will remember the datedif for other application however
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.