[Solved] Formula for dates

[Imtom.113]

Hi all... first post. I did look thru posts, but did not see an answer that applied exactly. I am building an equipment depreciation schedule. I need a formula that will calculate the number of months (as an integer) between a variable purchase date and a fixed end date. Any assistance on this would be greatly appreciated... THx, Tom

[Villeroy]

MONTHS is the name of the function.

[robleyd]

The Help - F1 - is also a good resource; search it for month.

[Imtom.113]

I keep trying to post that my question was solved, but not having any luck? What am I doing wrong ?

[robleyd]

How to tag a topic as solved.

In your first post, click the Edit button. Go to the subject line and add [Solved] at the beginning of the subject.

Then select the green tick as the Post icon (just below the subject line). Preview if you wish to see how it looks.
Finally, hit Submit - done!