Calculating the difference in months

[Starmo]

Hello everyone!
How to calculate the number of months between a date and today and to multiply the number of months obtained by multiplying it by some number.
Thanks!

[isladogs]

Use the Month and Date functions. e.g.

Month(#11/8/2017#)-Month(Date())

Result = 5

To multiply that by e.g. 5, its

5*(Month(#11/8/2017#)-Month(Date()))

P.S. Welcome to the forum

[Starmo]

Thanks for the welcome!
At my quaery this code is not working. Maybe because the date is set in dd.mm.yyyy in me?
This is all related to the query of "Help for my problem". I was trying to do something ...

[isladogs]

When using dates in VBA code you have to convert the dates to mm/dd/yyyy or yyyy-mm-dd format
Unless you do so, results will be unpredictable

So use something like this:

Month(Format(mydate,"mm/dd/yyyy"))-Month(Date())