Subtract days from a date

You can subtract days from a date by


Cell "A1" displays the current date.
Cell "A2" displays the current date and time.

 A
1=TODAY() = 09/07/2020
2=NOW() = 7/9/2020 12:28

Built-in Functions

TODAY - The serial number representing today's date.
NOW - The serial number of the current system date and time.


Related Formulas

Add days to a date including weekends
Subtract business days from a date
Number of days in a particular month
Number of days between 2 dates
Number of days left in the current year


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