Number of months between 2 dates
|1||=TODAY() = 02/01/2020|
|2||=NOW() = 1/2/2020 8:58|
|3||=DATEDIF(A1,A2,"M") = 0|
|4||=DATEDIF("01/01/2003","28/04/2003","M") = 3|
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.
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