How to calculate age using date of birth in excel in Hindi?

Image Source: Unsplash.com Learn more

MS Excel में DATEDIF Function क्या है?

[{"selector":"#anim-8aa34350-f420-4a78-b1f7-503dc7c8768d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1fd3ffdc-80eb-4eeb-a74c-317ad2a5b37d","keyframes":{"transform":["translate3d(114.64968%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Image Source: Unsplash.com Learn more

DATEDIF Function का उपयोग हम किन्ही दो दिनांक के बीच के अंतर को निकालने के लिए करते हैं।

[{"selector":"#anim-f95eefa1-d3ea-4589-b158-552cda6f9225","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f9a4518c-f330-45f4-93fb-c0e4b715014a","keyframes":{"transform":["translate3d(111.74699%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Image Source: Unsplash.com Learn more

यह बाकी Excel Function की तरह सामान्य तौर Syntax नहीं दिखाता हैं, लेकिन आप इसका सही तरीके से इस्तेमाल करके अपना रिजल्ट पा सकते हैं।

[{"selector":"#anim-8d18d2f1-eb44-4fbe-ac57-1badcd007d57","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-52d70639-b988-48f5-8839-dcb17d4975e2","keyframes":{"transform":["translate3d(112.04820%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Image Source: Unsplash.com Learn more

Syntax =Datedif(start_date,end_date,format_type)

[{"selector":"#anim-2a8a64ad-8f33-408e-92e4-8ed14cb1eca7","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1368a158-c629-4867-92e4-f4032e8f2f70","keyframes":{"transform":["translate3d(108.98203%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Image Source: Unsplash.com Learn more

तो हमने =DATEDIF(H2,I2,”Y”) का इस्तेमाल किया जिसमे हमने Start date में हमने Date of Birth और End date में Today’s Date को इन्सर्ट किया हैं। जिससे हमे 27 Age मिल गई।

[{"selector":"#anim-36a23a90-2e29-4edd-b29b-22b023caea25","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-74e4375e-9798-4c44-ad93-e6ced56d549b","keyframes":{"transform":["translate3d(112.95182%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Image Source: Unsplash.com Learn more

Learn More about Excel Function

[{"selector":"#anim-1038b347-f60d-4a3c-8593-dc556477ada8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-740045bd-98d0-46c7-a43f-3d2612093744","keyframes":{"transform":["translate3d(-111.34969%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Image Source: Unsplash.com Learn more

Thank you for watching

[{"selector":"#anim-75b05f5a-266f-4d04-8d07-ae058d731c32","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-abafde63-0575-414c-93fb-782004976f5f","keyframes":{"transform":["translate3d(-113.49693%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more