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


Example

 A
1=TODAY() = Friday 01 March 2024
2=NOW() = Friday 01 March 2024 07:54:08

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


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