How to add weeks to a date in Excel

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 c

How to add weeks to a date in Excel

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".A1=TODAY() = Saturday 02 July 20222=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.

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

Video liên quan