Number of months between 2 dates


 A
1=TODAY() = 02/12/2019
2=NOW() = 12/2/2019 7:03
3=DATEDIF(A1,A2,"M") = 0
4=DATEDIF("01/01/2003","28/04/2003","M") = 3

Built-in Functions

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


User Defined Function

DATEDIFF - Returns the number of units 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


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top