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() = Saturday 02 July 2022
2=NOW() = Saturday 02 July 2022 05:11:55

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


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