Add years to a date

You can add a certain number of years to an existing date by adding the corresponding number of days in that year.

 A
1=TODAY() = 02/10/2019
2=NOW() = 02/10/2019

Built-in Functions

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


Related Formulas

Add days to a date including weekends
Add months to a date
Add weeks to a date
Subtract years from a date
Number of days in a particular year
Number of years between 2 dates
Return a person's age in years


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