Subtract days from a date

You can subtract days from a date by

1=TODAY() = 01/07/2024
2=NOW() = 7/1/2024 6:51

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

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