Number of days between 2 dates ignoring months 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

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 years


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top