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".


1=TODAY() = Tuesday 23 May 2023
2=NOW() = Tuesday 23 May 2023 13:17:15

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".

Built-in Functions

NOW - The date serial number of the current system date and time.
TODAY - The date 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

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