NETWORKDAYS function in excel

By Satish Dhawale Learn more

- NETWORKDAYS function क्या है? - NETWORKDAYS Function के Syntax में argument? -NETWORKDAYS Function का उपयोग क्यूँ किया जाता हैं?

[{"selector":"#anim-bb3c4499-9c44-4e77-b3c6-86496189c25e","keyframes":[{"offset":0,"transform":"translate3d(0, -171.22041%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -48.147179292%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -16.368671196%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -6.146812719%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.6710383959999997%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}] [{"selector":"#anim-a7517fa6-20e8-4dde-ae82-394c40d2b33b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ed1415ba-06be-4f98-b8fd-7088473acb0a","keyframes":{"transform":["translate3d(-159.21789%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish Dhawale Learn more

MS Excel में NETWORKDAYS का उपयोग दो दिनांक के बीच मे कुल कार्य दिन यानि Total working days को पता करने के लिए किया जाता हैं।

[{"selector":"#anim-0b4ffeac-28ff-4eef-b96a-5c106ac2214b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e3d49405-165e-456c-95eb-724f68c79305","keyframes":{"transform":["translate3d(-118.39464%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-80c22b65-cb17-4b87-b14c-c1de398e0aa9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-993c6f7f-ad85-43df-b5f5-d7639731da8e","keyframes":{"transform":["translate3d(165.36314%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish Dhawale Learn more

जिसमें NETWORKDAYS सप्ताह ही छुट्टी (शनिवार और रविवार) को छोड़ के दिए गए दिनांक के बीच के Total working daysको निकालने मे मदत करता हैं।

[{"selector":"#anim-936dbb4c-4d0c-4a1c-a6c8-5c5753a123ff","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3f2762d1-a657-4f7f-9cfb-b215f029d459","keyframes":{"transform":["translate3d(165.36314%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b70b7d47-bab5-4ad8-83de-e1cd375e1e8a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3ea3f0cf-4990-4ebd-8e77-3bc40938249e","keyframes":{"transform":["translate3d(-117.6282%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish Dhawale Learn more

यदि के आपके दिनांक के बीच मे कोई अतिरिक्त छुट्टी (शनिवार और रविवार के अलावा) जैसे कोई त्योहार, तो आप उसे भी इक्स्क्लूड कर सकते हैं।

[{"selector":"#anim-e43af173-124e-4183-bdff-89644af15bb4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-59d9c55f-127f-4282-8ae3-1cf98398991f","keyframes":{"transform":["translate3d(0px, -159.74983%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f1fa89f1-e0bb-441c-a4cd-9dd3a59dbe9d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ca583e85-e021-4947-a237-ca07f1ee9055","keyframes":{"transform":["translate3d(0px, 203.09566%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish Dhawale Learn more

NETWORKDAYS Function Syntax =NETWORKDAYS(start_date, end_date_months)

[{"selector":"#anim-5086d053-bbde-4977-a636-dff84a845631","keyframes":[{"offset":0,"transform":"translate3d(0, -243.85577%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -68.572242524%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -23.312611612%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -8.754422143000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -3.804150012%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}] [{"selector":"#anim-cba10008-802b-438d-a5fe-c7661e58594b","keyframes":[{"offset":0,"transform":"translate3d(0, -261.30459%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -73.47885070800001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -24.980718804000002%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -9.380834781%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -4.076351604%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}] By Satish Dhawale Learn more

नीचे आपको एक डाटा दिख रहा है जिसमे Column A मे Start Date और Column B मे End Date सीख रहे हैं। साथ ही हमें Holiday Days की लिस्ट भी दी गए। हमें यहाँ हर महीने में कितने कार्य दिन यानि Working days होंगे ये पता करना हैं।

[{"selector":"#anim-dd897555-3463-4ac6-93ee-dbdd8db8f85e","keyframes":[{"offset":0,"transform":"translate3d(0, -175.95183%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -49.477654596%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -16.820994948%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -6.316670697%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.7448485479999998%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1600,"fill":"both"}] [{"selector":"#anim-576c749e-14cf-4050-a602-7016ab3c3643","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9f246b48-1643-480d-9447-f7068d3eb635","keyframes":{"transform":["translate3d(-110.30303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish Dhawale Learn more

[{"selector":"#anim-1bdd0d9c-c675-4512-9792-36e8b2e35f61","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b5303e3c-3512-469f-95b8-8517c719fc6f","keyframes":{"transform":["translate3d(-112.42425%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-05883922-1e31-4668-9ff4-2f67c8c70bbc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-88898ff1-d7fe-400c-93bc-cf59b13ab96e","keyframes":{"transform":["translate3d(114.42007%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish Dhawale तो आप देख सकते हैं कि हमने यहाँ NETWORKDAYS function का इस्तेमाल किया हैं: – Start date: इसमें हमने Column A के Cell को सिलेक्ट किया हैं, जोकि हमारी Start date होगी। – End date: यहाँ हमने Column B के Cell को सिलेक्ट किया हैं क्यूंकी यह हमार End date हैं। – [holidays]: यहाँ हमे list of holiday days की रेंज E2:E8 को सिलेक्ट करेंगे। जो हमें Working days में नहीं जोड़ना हैं। Learn more

आप NETWORKDAYS function की प्रैक्टिस करने के लिए Excel file को टेलीग्राम चैनल से डाउनलोड कर सकते है।

[{"selector":"#anim-c2192cd5-f48d-496c-8ff3-95fc3bce03ed","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ab1580ac-e857-473f-9662-81c2b1021a35","keyframes":{"transform":["translate3d(-113.0303%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-68dd10aa-9c5b-4faa-996a-56f178282cbb","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b9ce4f5d-22fb-4a8d-b2f4-d040455409c7","keyframes":{"transform":["translate3d(112.97469%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] By Satish Dhawale Learn more