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

 A
1=TODAY() = Thursday 01 October 2020
2=NOW() = Thursday 01 October 2020 07:52:21
3=TODAY()+1 = Friday, 02 October, 2020 12:00 AM
4=TODAY()+7 = Thursday, 08 October, 2020 12:00 AM
5=T(DAY(TODAY())&"/"&MONTH(TODAY())&"/"&YEAR(TODAY())) = Thursday, 01 October, 2020 12:00 AM
6=DATEVALUE(A5)+0 = Thursday, 01 October, 2020 12:00 AM
7=DATEVALUE(A5)+1 = Friday, 02 October, 2020 12:00 AM
8=DATEVALUE(A5)+7 = Thursday, 08 October, 2020 12:00 AM

Built-in Functions

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.


Related Formulas

Add business days to a date
Add business days to a date changing the days of the weekend
Add days to a date not landing on a weekend
Number of days in a particular month
Subtract days from a date


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