Number of days between 2 dates

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


 A
1=TODAY() = Tuesday 05 January 2021
2=NOW() = Tuesday 05 January 2021 13:26:48
3=A1+7 = 1/12/2021 0:00
4=A1+14 = 1/19/2021 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


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