Thread: What is the formula for calculating the number of months passed?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek
 
Posts: n/a
Default What is the formula for calculating the number of months passed?
=DATEDIF(Date1,Date2,"m")

Prerequisite: Date1 <= Date2

Teri wrote:
I need a formula that looks at dates and calculates the number of full months
from one date to the next. Can anyone help with this?

Thanks -
Teri
Reply With QuoteReply With Quote