Add weeks to a date

You can add a certain number of weeks to an existing date by adding the corresponding number of days in a week.
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".

 A
1=TODAY() = Wednesday 02 September 2020
2=NOW() = Wednesday 02 September 2020 08:55:08

Built-in Functions

NOW - The serial number of the current system date and time.
TODAY - The serial number representing today's date.


Related Formulas

Add days to a date including weekends
Add months to a date
Add years to a date
Subtract weeks from a date


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