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() = Thursday 02 April 2020|
|2||=NOW() = Thursday 02 April 2020 08:00:28|
NOW - The serial number of the current system date and time.
TODAY - The serial number representing today's date.
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
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top