Subtract days from a date

You can subtract days from a date by


 A
1=TODAY() = 01/10/2024
2=NOW() = 10/1/2024 6:08

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