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.

Built-in Functions

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