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() = Monday 01 March 2021
2=NOW() = Monday 01 March 2021 11:15:47

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


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