How to use the DAY function in excel in Hindi?

Image from Unsplash.com Learn more

MS Excel में DAY function क्या है?

[{"selector":"#anim-8e60738f-fe8a-4a4f-b35d-f3dec5903775","keyframes":[{"offset":0,"transform":"translate3d(0, -444.55908%, 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, -125.010013296%, 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, -42.499848048000004%, 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, -15.959670972%, 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, -6.935121648%, 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"}] Image from Unsplash.com Learn more

एक्सेल में DAY function का उपयोग महीने के दिन को नंबर के रूप में निकालने के लिए किया जाता है। Excel में DAY function यह Date और Time की कैटेगरी में आता है।

Image from Unsplash.com Learn more

DAY function Syntax

[{"selector":"#anim-ea9ed200-b40b-4190-be1d-4f2578efec13","keyframes":[{"offset":0,"transform":"translate3d(0, -639.06828%, 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, -179.706000336%, 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, -61.094927567999996%, 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, -22.942551251999998%, 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, -9.969465168%, 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"}] Image from Unsplash.com Learn more

DAY(serial_number) – सीरियल_नंबर यह argument आवश्यक है। जिस दिन को आप ढूँढना चाहते है उस दिन दिन की तारीख देना होता हैं।

Image from Unsplash.com Learn more

Example of DAY Function in Excel in Hindi

[{"selector":"#anim-e6bde396-9a24-4733-be6b-213bdfbc9e36","keyframes":[{"offset":0,"transform":"translate3d(0, -336.89243%, 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, -94.734151316%, 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, -32.206916308000004%, 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, -12.094438237%, 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, -5.2555219079999995%, 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"}] Image from Unsplash.com Learn more

हमारे पास एक टेबल है जिसमें कुछ दिनांक दिए गए हैं और हमसे बोला गया है कि इन दिनांक में जो दिन है उनको अलग से निकालकर दिया जाए।

Image from Unsplash.com Learn more

तो जैसा कि आप देख सकते हैं इसके लिए हमने Day Function का इस्तेमाल किया है और Day Function में हमने उसके argument में जो दिनांक का कॉलम है उसकी सेल को सिलेक्ट किया।

Image from Unsplash.com Learn more

Download practice files

[{"selector":"#anim-05c280fc-d8bd-4b27-8045-81329653e045","keyframes":[{"offset":0,"transform":"translate3d(0, -412.60032%, 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, -116.023209984%, 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, -39.444590592000004%, 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, -14.812351488000001%, 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, -6.436564992%, 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"}] Image from Unsplash.com Learn more

तो आप हमारे टेलीग्राम चैनल Learn More पर जाके Day फंक्शन से जुड़ी प्रैक्टिस फाइल को आसानी से डाउनलोड कर सकते हैं। वह भी बिल्कुल फ्री में और साथ ही उसमें हमने प्रैक्टिस के लिए कुछ सवाल दिए हैं।

Image from Unsplash.com Learn more