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() = Tuesday 01 December 2020
2=NOW() = Tuesday 01 December 2020 06:42:53

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