Number of months between 2 dates
Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
|1||=TODAY() = Saturday 02 July 2022|
|2||=NOW() = Saturday 02 July 2022 05:11:55|
|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
DATEUNITS - 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
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top