Number of months between 2 dates

	A
1	=TODAY() = Friday 29 November 2024
2	=NOW() = Friday 29 November 2024 11:44:05
3	=DATEDIF(A1, A2, "M") = 0
4	=DATEDIF("01/01/2003", "28/04/2003", "M") = 3

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".

Built-in Functions

DATE - The date as a date serial number given a year, month, day.
NOW - The date serial number of the current system date and time.
DATEDIF - (Compatibility) The number of days, months or years between two dates.

User Defined Function

DATEDIFFERENCE - Returns the number of days, months or years between two dates.

Related Formulas

Return the current month
Subtract months from a date
Number of days in a particular month
Number of days left in the current month
Number of days left in the current year
Number of weeks between 2 dates