6,546 views
🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this Excel video lesson, we will learn how to calculate due date with business days, holidays or calendar days. The due date is nothing more than an end date from an initial date, that is, initial date plus days equals the end date. We will use formulas and functions in the Excel spreadsheet to solve this problem through a practical and step-by-step example. In the first example, we will see how to calculate calendar days in Excel, calendar dates, how to add dates in the Excel spreadsheet, how to add due days to a date, how to calculate due dates, how to calculate dates in Excel. In the second example, we will see how to calculate the due date considering the business days, that is, excluding Saturday and Sunday. In fact, you can also exclude other days of the week. You can consider Saturday and Sunday as business days. However, you can also choose other days to exclude, and in this way, you can calculate the due date excluding weekends, that is, a calculation with only one business day. And for this, we will use the WORKDAYS.INTL function. In the third example, we will calculate the due date disregarding the holidays, that is, we will consider the holiday when calculating the due date on the final date here in Excel. So, in this example, we will also consider the holidays along with the business days, for example, Saturday and Sunday. So, you can also calculate business days in Excel considering the holidays or a holiday calculation in Excel. In this way, we will learn how to exclude holidays in Excel. #ExcellentJoão #Excel #Dashboard