Excel in Hindi- How to use Date Function in Excel

Welcome to our Excel tutorial series! In this video, we'll dive into the world of date functions in Microsoft Excel. Master the art of handling dates, from basic formatting to advanced calculations. Whether you're a beginner or looking to level up your Excel skills, understanding date functions is crucial for effective data management and analysis.
Topic:-
1. Use Custom formatting to display the day of the week
2. Use TODAY function
3. NOW function to calculate the time
4. TEXT function to calculate Days and Month
5. DATE function to combine columns with date parts
6. YEAR function to extract the year part of a date
7. Use the MONTH function to extract the month part of a date
8. Use the DAY function to extract the day part of a date
9. Use the EOMONTH function to determine the last and first day of a month
10. WEEKDAY and WEEKDAY.INTL function
11. NETWORKDAYS and NETWORKDAYS.INTL function excel formulas in Hindi
12. Formula to Extract Day Name from Date in Excel
13. How to Calculate difference between two dates in Excel Hindi || in Number of Years/Months/Days
14. Date and Time Function in MS Excel in Hindi
15. Excel Weekday Function
16. How to use Today Formula in Excel in Hindi
To know more:- forms.office.c...
Excel workbook download link- skrlearningpoi...
#ExcelinHindi, #Skrlearningpoint, #Excel365, #Excel2016, #Sarabexcel
FB page: - / excelskrlearningpoint
For more videos- / skrlearningpoint
1. How To calculate difference between two dates in excel Hindi || in Number Of Years/Months/.Days
2. Formula to Extract Day Name from date in excel 2013|2016 - KZbin
3. Date and Time Function in Ms Excel in Hindi Language
4. 4.Excel Formulas Series Training || ALL DATE and TIME formulas in EXCEL (Excel 2016)
5. All date & time function in excel (Hindi)
6. MS Excel - Date Functions Part 1
7. Excel in Hindi - Date, Day, Month, Year Formula
8. NETWORKDAYS and NETWORKDAYS.INTL Function in Excel in HINDI - Lesson 48
9. Excel DAY Function | Formula | How to use DAY Function in Excel?
10. DAYS360 Formula In Excel Hindi 23
11. Excel in Hindi- How to use Date Function in Excel
12. Learn Excel😉 TODAY, NOW, DAY, MONTH YEAR, DATE & TIME DIFF | Date-time (Temporal) Formulas.
13. 99% Excel MIS Reports need these Date formulas of excel
14. 72* How to use TODAY formula in Excel {Hindi}

[@ashishgusain9494]

Arey bhaii, kitne bdia se smjhaya h yr, i dont know why people haven't subscribed your channel yet.

[@MannuKashyap-x9c]

Bohot Help full hai thank you 😊

[@ankitsoni6954]

Our sir is very beautiful conversations between the so very happy student follow our guidelines class ke best teacher trainer ko khoob namaskaar hai

[@bheembheem-d2x]

Very very nice video😊🙏🙏🙏

[@sarikavaidya6681]

Ur chennal is very nice keep it up I like it

[@Namobhuddhyashakyagruop123]

Excellent sir 👌

[@sumansharma2061]

Very nice, precise and clear training session, thanks a lot sir !!!!!!

[@anitawritings4060]

It's really nice nd helping sir! Pl z keep inspiring

[@maryammalik6780]

Video to bhai bht achi bani hai keep it up ❤️

[@bhardwaj7272]

Excellent---SuperMan---Well teaching method.............

[@SKRLearningPoint]

Many thanks!

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@nazakatali3778]

This is really helpful, Thanks a bunch! for this precise and detailed video

[@rskcreator3740]

Thanks sir ❤

[@shubhamgautam8713]

Very useful and understandable. Keep it up !! 😀

[@shubhamgilhotra110]

Bro yr seriously very good

[@RahulKumar-ly6ly]

Thanks sir very helpful video sir

[@salikramchapekar3219]

VERY NICE SIR

[@rajpanwar11]

Great Job 👍👌👍👏

[@LOVE-ue7un]

woow tq u sir🎉

[@ShahzadAli-xr7tk]

Excellent

[@tanishq1294]

Thank you sir.

[@ThKur8090]

Very nice sir

[@AdilKhan-no2mz]

Thank you so much, I am appreciating your (date formula) work in excel

[@chaseezra5450]

i know im randomly asking but does any of you know of a way to log back into an instagram account..? I somehow forgot the password. I would appreciate any assistance you can offer me.

[@keagandominick8343]

@Chase Ezra instablaster :)

[@chaseezra5450]

@Keagan Dominick Thanks so much for your reply. I found the site on google and im trying it out atm. Seems to take quite some time so I will get back to you later with my results.

[@chaseezra5450]

@Keagan Dominick it did the trick and I actually got access to my account again. Im so happy! Thanks so much, you saved my account :D

[@keagandominick8343]

@Chase Ezra no problem =)

[@rishijain9540]

Simple and good explanation

[@SKRLearningPoint]

Thank you 🙂

[@rajubhardwaj6716]

👍👍👍👍👍👍👍👍👍👍 Superrrb

[@kansingh5968]

Nice video thanks sir

[@basicneed9818]

It's very helpful...thank you

[@SKRLearningPoint]

Glad it was helpful!

[@Amisha301]

Thanks sir🙏🙏

[@marufsaiyad632]

Super Trike thank you sir

[@SKRLearningPoint]

Welcome

[@ChillTime2409]

Nice

[@ExcelTricksentertainment]

Thanks

[@riyazmohdansari6135]

Thnx bhai.... For sharing u r valuable knowledge... Plz make video on .. Advance If conditions 🙏🙏🙏🙏

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@ArmanKhan-tb7rb]

Sir kya ye sari formulas other apps me bhi use hota hai ya fir special excel me hi hota hai

[@susamaaleya3305]

Thank you sir

[@SKRLearningPoint]

Welcome

[@urmila731]

Iam not able to download the practice file, showing error.

[@rajeshchoudhary2520]

Nice Video

[@crystal_unclear]

Agar Feb 10, 2023 esa rahega to usko 2/10/2023 me convert karne k liye konsa formula lagaye

[@SKRLearningPoint]

No formula needed, just change format go to format cell use Custom then use -> MM/DD/YYYY

[@nitinc2373]

Nice Video, I have one query, I want to collect Working Dates for trading, i. e,(From Monday To Friday),I use Today Formula, its working nice but when Saturday and Sunday comes, or Holiday comes all data showing error , what should I do to fix this problem? Please help me.

[@SKRLearningPoint]

User networking.intl formula

[@priyaharshitha6586]

#skrLearningPoint i am not able to download the excel file mentioned in the description

[@netajibhosale3212]

WELL TEACHING

[@SKRLearningPoint]

Thank you

[@brittokhan5278]

vedio sound volume is low. pls increase the volume

[@Rk-ik5lz]

Good explanation but screen not clear can't find what ur entering numbers and formula... ????

[@sudhanshu522]

Bro setting m jake 1080p kro

[@SanaRao-p6x]

Sir by following guidance i am not enabled to convert dates into days, Please advise

[@SKRLearningPoint]

Ues Datedif(StartDate,EndDate,”M”)

[@mohanpal13555]

Awesome

[@rajpanwar11]

जय हो राम जी, की भाई साहब। आप बहुत अच्छा पढ़ाते हो। पर eomonth वाले फॉर्मूला में जब ऐसे( =eomonth(11/01/2010, 0) लगाता हूं तो वल्यू 44500 आती है। क्या करू बताए। प्लीज

[@SKRLearningPoint]

Format cell me ja kr date format select kr lo bs

[@ImdadHussainHussain-gk6hn]

HI SIR I HAVE ONE PROBLEM THE WHEN WE ISSUED A CHEQUE AGAINST FUTURE DATE NOW I WANT WHEN THE FUTURE DATE WILL BE COME THE CELL AMOUNT AUTOMATICALLY SHIFT TO NEXT CELL AND THE OLD CELL SHOW ZERO

[@sunilathwal8625]

Sir, through link Excel sheet is not being downloaded here.Error coming

[@RohitPatidarOffice]

sir mere google sheet me formula suggestion nhi aa rhe h,pehle aate the ab band ho gye h ,koi setting bataye

[@MehediHasan-rj9w]

Sir mein ek invoice due date calculate karna chahtahu. The due date should be 15 consecutive days after the invoice is issued. The due date cannot be a holiday (here the holidays are Fri, Sat, and Sunday). Can you give a formula? Suppose an invoice is issued on 2 Feb 2023. So the due date would be 2 Feb +15 days = 17 Feb. Since 17 Feb is Fri so it wouldn't. the next day is Sat and Sun also canceled same reason. So the result would be 20 Feb 2023. Please help

[@SKRLearningPoint]

Use networkday.intl and Workdayday.Intl formula

[@MehediHasan-rj9w]

@@SKRLearningPoint Sir all these formula excludes holidays between dates.

[@SKRLearningPoint]

Yes 👍🏼

[@shiwanisaw05]

Sir maine date khud se likha to uspe na NUMBER FORMAT wala Date option activate ho rha h na hi kuch change ho rhi h date me or Nahi Conditional formatting wala Date occuring option . Aisa Q sir ?

[@sksalman2748]

Are you teach advance Excel course

[@theescanor8985]

Discription me jo link open n hori hai boss... Can't read the file... Send me the link plz.. Wanna practise. Thnk u

[@iZacq]

what if want Weekdays to show in Column A Before then Date in B column every time i But Date in B column, it should show the WeekDay in coloumn A but in Column B i want my Date to show Like This >>> 27-Sep-23 Please

[@akashhela8521]

Download link nahi open ho rah hai sir.

[@sudhanshu522]

Sir eomonth wala formula m use kr rha hu 02-05-1992 pr to wo 38503 show kr rha h aisa q??? 😢😢😢

[@SKRLearningPoint]

Format change, or convert in Date format simple. Sorry for late reply.

[@binaykumarnayak9114]

Thank you so much . Edate and Datevalue to be added .

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@rishijain9540]

File is unable to download

[@nomulanikhila4722]

But how to calculate absent days in a month

[@dheerajphadatare5135]

Thank you sir, sir please make another videos on financial tab all in excel please.......

[@rohansharma-11]

Sir daliy volatility nikale ka formula batiye please?

[@Seriously_Busy_in_Patna]

Well Sir. is there any formula for making Calender ?

[@parhladsharma]

Sir 01/09/2021 me 100 days add karke new date a jaye ye formula bataye

[@SKRLearningPoint]

Use workdaysintl formula

[@parhladsharma]

@@SKRLearningPoint Thanks Sir

[@jaynarayansingh1323]

Employee card scanning sheet kaise banaye ki jisase employee ke in ya out time so ho. Please explain this formula🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@hariprakashlodhi755]

Ok

[@jaynarayansingh1323]

@@hariprakashlodhi755 bro please help me care scaning sheet me employee ka card scan karane par time bhi aana chahiye.mene bhi ek formula pta Kiya h =If(isbkank (A2),"",now()) but isame ek problem h card scan karane par sabhi row me ek hi time dikhata h.

[@premprakash3339]

How can set a "under age" alert msg for below 18 yrs. of age.

[@SKRLearningPoint]

Use IF & DATEIF formula

[@Deependra1991]

how to download workbook as it is showing view only mode in ms 365 online.

[@muhammadhusnain2258]

Sir g formula ko freez kasay kartay Hain please tell me

[@SKRLearningPoint]

Excel in Hindi- Absolute and Relative Cell/Range References #SkrLearningPoint kzbin.info/www/bejne/bYGsqayNd7udnbM

[@SKRLearningPoint]

Excel in Hindi- Mixed Cell References #SkrLearningPoint kzbin.info/www/bejne/b3aVZH-la9yJbKc

[@vivekkumari8292]

Ye semicolam kya

[@somthingdiff2050]

how to find out {like given date 1-3-2001 and for today() } total no days till now

[@railtechecr592]

Agar Tomorrow ka date aaj ke date me chahiye to kya kare?

[@SKRLearningPoint]

=Today()+1

[@dharmeshsingh8455]

Excel sheet unable to download

[@muhammadzubair7188]

sir agr month ka name dia ho ya month ka number dia ho to us month k total days kese find kren gy

[@SKRLearningPoint]

Use Eomonth formula

[@SAHIBSINGH-fk1uv]

Jese 1-4-2020 ko ek din before ko kese kre

[@rajeevgosavi4514]

WORKBOOK DOWNLOAD LINK IS ONLY A VIEW LINK AND CAN'T BE DOWNLOADED

[@sandeepgaur8920]

sir, please send me the complete sheet of all commands of date and time

[@rajeevgosavi4514]

Sir, We can't download workbook link, as it can be only viewed.

[@SKRLearningPoint]

I checked, but its working

[@Its.my.pleasure]

Ye sare formulae excel 2007 me hai kya?

[@SKRLearningPoint]

.INTL formula not working in excel 2007

[@kokitormmrj2320]

Can you put the video in CC English please?

[@ruchitajambhulkar8864]

If I wanted last date as in days count how can I do that...

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@lovejob-wz8hf]

sir please share the file with other way not able to access the file

[@Sukoonbykrunal]

Can we know a date from given days??? Like month ke last monday ya sunday par kaunsi date hogi??

[@SKRLearningPoint]

You can use Eomonth with networking days

[@Sukoonbykrunal]

@@SKRLearningPoint thank u

[@SKRLearningPoint]

@@Sukoonbykrunal 31/03/2020 =IF(BH16="","",IF(AND(WEEKDAY(WORKDAY.INTL(EOMONTH(BH16,1),5,1,LIST!$Q$2:$Q$32))=6,WEEKDAY(WORKDAY.INTL(EOMONTH(BH16,1),5,1,LIST!$Q$2:$Q$32))=1),WORKDAY.INTL(EOMONTH(BH16,1),5,1,LIST!$Q$2:$Q$32)-1,WORKDAY.INTL(EOMONTH(BH16,1),5,1,LIST!$Q$2:$Q$32))) [7th May]

[@shaiksufiya4927]

Could u help me regarding split function with formula. I like the way you explain sir. Tq. Hope u will help me.

[@SKRLearningPoint]

kzbin.info/www/bejne/q3iVdZqOlLuBntk

[@SKRLearningPoint]

kzbin.info/www/bejne/f4SQpWabftymobs

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@parvezakthar2231]

Hello

[@pcommunication5817]

Workbook not opening

[@shanurshaikh1173]

I want formula or solutions for auto fill renew date/ valid upto in front of start date eg. 20/04/2018, 3/8/2020 , 25/7/2014 it becomes 19/04/2020, 2/8/2021 & 24/7/2020 year must be current year but if start date is current year then it will be next year

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@Babita377]

Dale hua date se ajki date me kitina din hua kete pata kare

[@SKRLearningPoint]

=datedif(startDate,Today(),”D”)

[@dnyanendra8138]

07.03.2002 is not changing date format as 7 march 2002 why ?

[@SKRLearningPoint]

1st you need to change Dot (.) into (/ )

[@iyobosaedosa3874]

Really a superb video. Please can we get the English version of this. It will be really helpful. Thanks 👍.

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@anshulchaturvedi7382]

How to find next 15 days date when all days of the year are working days (no holyday). Please provide formula.

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@nenumovielover]

Practice link send me sir in comment box

[@u_have_2_know]

"Last day of Month" formula is not working 😕

[@taufiqbaroda2475]

Ek column me August likha he use ek sath formula bar se January karna ho to kaise kare.

[@SKRLearningPoint]

Use Eomonth formula

[@Travelwithme0504]

how to add next year with year() function.

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@technofy]

how to calculate total 31 days month between two dates

[@SKRLearningPoint]

Use networkingday and workingdays formulas. kzbin.info/www/bejne/aKrJkHiOh9mMh68

[@AnilYadav-ow6zk]

Y

[@AbdulHakim-ns3px]

Sound Problem

[@pratikpatade7844]

Hello Sir, Can you help me in getting an user define function to get monday dates between two dates? For Ex: Start date = 4/4/2020 & End date= 5/5/2020, then result should give me a list of Mondays dates dd/mm/yyyy dd/mm/yyyy dd/mm/yyyy ......so on Please help me this is very urgent.. Thank u in advance.

[@mrtrickgamingindia2395]

kzbin.info/www/bejne/a4SYdoN9aqZ-p9k

[@NSMS57]

How to write'2019-07' in date format it needs to change everymonth say 2019-08,2019-09.... please let me know

[@SKRLearningPoint]

Use TEXT function, It's very easy

[@NSMS57]

@@SKRLearningPoint kindly provide the formula if possible, thanks

[@SKRLearningPoint]

Share me your data with example [e-mail]

[@NSMS57]

@@SKRLearningPoint Hello, my requirement.is I have two excels one with employee id ,name, gender, address and second excel with employee id company salary and around 100 columns of other data I want to filter the second excel with first excel employee id and get some cell data related to the employee from the second excel and paste it in first excel.(say employee id is 14793556 for this employee from the first excel I will search in the second excel and from the second excel I want to copy data related to this employee in the columns DA3 to DF3 ) then take these values and paste in first excel) like wise for the rest of employee ID's in the first excel.... kindly guide me on this...Thanks in advance

[@kumarshubham9811]

volume bilkul sutta k dala h

[@pankajgirdhar2502]

Awaaj bhoot slow ha

[@SKRLearningPoint]

Thanks for your feedback 😁

[@armaanmalik278]

Not clear vision

[@hariprakashlodhi755]

Plz call me help

[@ashleyhenryfanclub6501]

Ghatiya explanation