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