Number of months between 2 dates
|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|
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
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top