Solved

# Count months between 2 dates

Posted on 2012-03-21
Medium Priority
303 Views
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
0
Question by:recycleaus
• 2

LVL 4

Accepted Solution

ltsweb earned 2000 total points
ID: 37750670
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)

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?)

Regards!
0

LVL 8

Expert Comment

ID: 37750850
Another option:
=DATEDIF(A3,TODAY(),"m")
0

LVL 4

Expert Comment

ID: 37750894
WCHH, That is a good one too.
0

Author Comment

ID: 37750915
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

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month16 days, 2 hours left to enroll