Number of months between 2 dates


 A
1=TODAY() = Thursday 09 July 2020
2=NOW() = Thursday 09 July 2020 12:28:52
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

DATEUNITS - 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


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