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.

1=TODAY() = 01/05/2022
2=NOW() = 5/1/2022 18:37

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

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