98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Mark East
Mark East
Resolved · Medium Priority · Version 2003
Selina has attended:
Excel Intermediate course
Mark East
When calculating the difference between two dates (possibly over more than a year), how do I show the result as a number of Months? Also can this be done as a formula to include today's date as the latter of the two dates?
RE: Mark East
Hi Salina
If cell A1 is date from last year and cell A2 is current date you would do the formula as follows:
In cell A3 you would do a subtraction of the 2 cells and then format the cell as a number. This would give you number of days so we could make it a monthly figure by dividing by 30. Your formula would look like this:
=SUM(B1-A1)/30
Ensure that you have formated the cell as a number.
This cell would round at the moment and for your purposes you would want excel to always round down and never up. So you will need to do a further formula in cell D1 to force a round down. our formula would look like this =ROUNDDOWN(C1,0)
Hope that helps.
David
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hide data in Excel WorksheetsLet's say you have some data in cell 'C5' you would like to hide from the casual viewer. |