Number of months between 2 dates ignoring days and years
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".
|
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.
User Defined Function
DATEUNITS - Returns the number of units between two dates.
Related Formulas
Number of years months days from a date
Number of days between 2 dates ignoring months and years
Number of days between 2 dates ignoring years
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top