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".

 A
1=TODAY() = Sunday 01 May 2022
2=NOW() = Sunday 01 May 2022 18:37:54

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