Number of days between 2 dates

You can return the number of days between 2 dates by subtracting them.


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() = Saturday 02 July 2022
2=NOW() = Saturday 02 July 2022 05:11:55
3=A1+7 = 7/9/2022 0:00
4=A1+14 = 7/16/2022 0:00
5=DATEDIF(A1,A3,"D") = 7
6=DATEDIF(A1,A4,"D") = 14
7="01/08/03"-"28/08/03" = -27
8=A4-A1 = 14

Built-in Functions

TODAY - The serial number representing today's date.
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.


Related Formulas

Number of days between 2 dates excluding weekends
Number of mondays between 2 dates
Number of days in a particular month
Number of days in a particular year


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