Add days to a date including weekends
You can add a certain number of days to an existing date by adding that corresponding whole number.
Dates are represented as date serial numbers.
Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays 1 day added to that date.
Cell "A4" displays 7 days added to that date.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".
DATEVALUE - The date serial number given a date in text format.
DAY - The day as an integer given a date serial number.
MONTH - The month as an integer given a date serial number.
NOW - The serial number of the current system date and time.
T - The text string of the value given.
TODAY - The serial number representing today's date.
YEAR - The year as an integer given a date serial number.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top