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

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