calculate the amount of months

  • Thread starter Thread starter Louis
  • Start date Start date
L

Louis

What would the formula be to calculate the number of
months between 2 dates?

Thanks

Louis
 
The usually-undocumented function

=DATEDIF(date1,date2,"m")

will return the difference in months.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Calculate Months to Determine Length of Service 7
Calculate the first monday of a month in the future or in the past 3
Total number of months. 4
Calculate elapsed time excluding specific timeframe 10
Calculate interest & withdrawals 0
Allocate Value Across Monthly Periods 1
Difference between last date of month and given date 3

Back
Top