Solved

Count months between 2 dates

Posted on 2012-03-21
4
295 Views
Last Modified: 2012-03-21
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
Comment
Question by:recycleaus
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
ltsweb earned 500 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)

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
 
LVL 8

Expert Comment

by:wchh
ID: 37750850
Another option:
=DATEDIF(A3,TODAY(),"m")
0
 
LVL 4

Expert Comment

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

Author Comment

by:recycleaus
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
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.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question