Calculate Working Days Between 2 Dates in Excel [2024]

Step by Step Video on how to find the difference between 2 dates in Excel (Works on Excel 365, Excel 2019, 2016, 2013, 2010, 2007, Excel for Mac)
========================================
========================================

If you want simply a difference in dates, it is possible easily. But if you want to pick only working days, from Monday to Friday, and exclude the Saturday and Sunday, then Learn this nifty trick from ExcelChamp Founder Vinai Prakash.

Here Vinai will show you how in-built Excel function NETWORKDAYS() can be used to find the difference between 2 days, only counting the working days.

#ExcelChamp, #ExcelTips, #ExcelTricks, #MicrosoftExcel, #ExcelChampVideos, #BestExcelTips, #ExcelForBeginners, #PowerBITips, #VinaiPrakash, #ExcelDateDifference, #ExcelNetworkDays, #Networkdays, #DateDiff, #ExcelDates
============================================================
===========================================================
============================================================

[jayagopi]

Pls help! Developed a table, and need to extract the data from the table to another summary table. Day To Date and year to date, able to extract the Year To Date but unable to extract the Day To Date as this value need to be updated as per the current day.How to to do it?