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.


Example

 A
1=TODAY() = Sunday 19 May 2024
2=NOW() = Sunday 19 May 2024 13:52:44

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".


Built-in Functions

NOW - The date serial number of the current system date and time.
TODAY - The date 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


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