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.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A
1=TODAY() = 02 Monday December 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