Скачать или смотреть How to Add Days, Months, Weeks, Years to Dates in Excel - XDATE Function

How to Add Days, Months, Weeks, and Years to Dates in Excel

Download DataFX free Excel add-in:
https://exceldashboardschool.com/free...

In this video, I'll show you how to add days, weeks, months, or years to a given date using a single function. The XDATE function is a part of our huge library. You can find it in the Date and Time section.

Type an equal sign and use XDATE. I want to add 5 days to the date, so type five and add a comma. The third argument is the most interesting part of the XDATE function. You can add various types of time units using a single argument. To add days to the date, type 1. To add weeks to the date, type 2. To add months to the date, add 3. Finally, use 4 to add a year to the date. I’m using days in the example, so type 1 as a third argument. Using this logic, you can easily add weeks, months, or years to the date.

Chapters:

00:00 Intro
00:18 How to Add Days, Months, Weeks, and Years to Dates in Excel

#excel #exceltips #exceltutorial