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 - 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".
NOW - The date serial number of the current system date and time.
TODAY - The date 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
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top