How to calculate Business Working Days in Google Sheets
The NETWORKDAYS function calculates the number of working days between two dates. The function excludes weekends (Saturday and Sunday) and can exclude holidays if you provide a list.
Syntax
=NETWORKDAYS(start_date,end_date,[holiday(s)])
start_date The date at which to start the calculation
end_date The date at which to end the calculation
[holiday(s)] An optional list of holidays to exclude from the count of days.
===============================================================================
Google Sheets for Beginners Playlist ⬇
▶️ • Googlesheets Tutorials for Beginners in Tamil
==========================================================
Query Functions in Google Sheets Playlist ⬇
▶️ • QUERY Functions in Google Sheets
==========================================================
Google Apps Script Playlist ⬇
▶️ • Apps Script Tutorials
==========================================================
Google Forms - Tutorial for Beginners in Tamil⬇
▶️ • How to create Google Form in Tamil
==========================================================
➽Follow Me :)
Instagram : / itzmedinesh.official
Telegram : https://t.me/itzmedinesh_tg
Facebook : / itzmedinesh.official
Twitter : / itzmedinesh_yt
Linkedin : / itzmedinesh
Tumblr : / itzmedineshofficial
YouTube : / itzmedinesh
============================================================
#NETWORKDAYS, #WORKDAYS, #GoogleSheets
============================================================