How to calculate workdays in Excel excluding holidays and weekends, and more.
In this video, I show you how to calculate dates in Excel. How to count the days between dates, how to count days excluding weekends or days off, and even how to count days excluding holidays and days off. Basically, in this Excel lesson, I show you how to calculate working days in various situations using some formulas, which are:
Subtraction, using the minus sign "-". Simply select the end date "minus" the start date.
Function =Days()
Function =TotalWorkDay()
Function =TotalWorkDay.Intl()
🔥 Learn Excel with me and become a Reference in the Job Market
http://excelentejoao.com.br/sejaexcel...
#Excelentejoao #Excel #Dashboard