Excel in Hindi- How to use Date Function in Excel

Поделиться
HTML-код
  • Опубликовано: 11 дек 2024

Комментарии • 159

  • @ashishgusain9494
    @ashishgusain9494 3 года назад +6

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

  • @ankitsoni6954
    @ankitsoni6954 Год назад +1

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

  • @MannuKashyap-x9c
    @MannuKashyap-x9c Год назад +1

    Bohot Help full hai thank you 😊

  • @bhardwaj7272
    @bhardwaj7272 4 года назад +2

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

  • @sumansharma2061
    @sumansharma2061 2 года назад +2

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

  • @maryammalik6780
    @maryammalik6780 3 года назад

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

  • @shubhamgautam8713
    @shubhamgautam8713 2 года назад +2

    Very useful and understandable. Keep it up !! 😀

  • @sarikavaidya6681
    @sarikavaidya6681 2 года назад

    Ur chennal is very nice keep it up
    I like it

  • @nazakatali3778
    @nazakatali3778 2 года назад +1

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

  • @nishashakya4913
    @nishashakya4913 2 года назад +1

    Excellent sir 👌

  • @AdilKhan-no2mz
    @AdilKhan-no2mz 4 года назад +2

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

    • @chaseezra5450
      @chaseezra5450 3 года назад

      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
      @keagandominick8343 3 года назад

      @Chase Ezra instablaster :)

    • @chaseezra5450
      @chaseezra5450 3 года назад

      @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
      @chaseezra5450 3 года назад

      @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
      @keagandominick8343 3 года назад

      @Chase Ezra no problem =)

  • @rishijain9540
    @rishijain9540 5 месяцев назад

    Simple and good explanation

  • @riyazmohdansari6135
    @riyazmohdansari6135 3 года назад

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

  • @rajubhardwaj6716
    @rajubhardwaj6716 4 года назад +1

    👍👍👍👍👍👍👍👍👍👍 Superrrb

  • @shubhamgilhotra110
    @shubhamgilhotra110 3 года назад

    Bro yr seriously very good

  • @crystal_unclear
    @crystal_unclear Год назад +1

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

    • @SKRLearningPoint
      @SKRLearningPoint  Год назад

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

  • @rskcreator3740
    @rskcreator3740 2 года назад +1

    Thanks sir ❤

  • @urmila731
    @urmila731 3 месяца назад

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

  • @basicneed9818
    @basicneed9818 4 года назад +1

    It's very helpful...thank you

  • @jaynarayansingh1323
    @jaynarayansingh1323 3 года назад

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

    • @hariprakashlodhi755
      @hariprakashlodhi755 2 года назад

      Ok

    • @jaynarayansingh1323
      @jaynarayansingh1323 2 года назад

      @@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.

  • @rajpanwar11
    @rajpanwar11 3 года назад

    Great Job 👍👌👍👏

  • @ShahzadAli-xr7tk
    @ShahzadAli-xr7tk 6 месяцев назад

    Excellent

  • @RahulKumar-ly6ly
    @RahulKumar-ly6ly 3 года назад

    Thanks sir very helpful video sir

  • @nitinc2373
    @nitinc2373 2 года назад +1

    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.

  • @salikramchapekar3219
    @salikramchapekar3219 3 года назад +1

    VERY NICE SIR

  • @priyaharshitha6586
    @priyaharshitha6586 8 месяцев назад

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

  • @ArmanKhan-tb7rb
    @ArmanKhan-tb7rb 2 года назад

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

  • @LOVE-ue7un
    @LOVE-ue7un Год назад

    woow tq u sir🎉

  • @marufsaiyad632
    @marufsaiyad632 4 года назад +1

    Super Trike thank you sir

  • @brittokhan5278
    @brittokhan5278 2 месяца назад

    vedio sound volume is low. pls increase the volume

  • @akashhela8521
    @akashhela8521 10 месяцев назад

    Download link nahi open ho rah hai sir.

  • @tanishq1294
    @tanishq1294 Год назад

    Thank you sir.

  • @sunilathwal8625
    @sunilathwal8625 Год назад

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

  • @ThKur8090
    @ThKur8090 Год назад

    Very nice sir

  • @rohansharma-11
    @rohansharma-11 2 года назад

    Sir daliy volatility nikale ka formula batiye please?

  • @kansingh5968
    @kansingh5968 3 года назад

    Nice video thanks sir

  • @sksalman2748
    @sksalman2748 3 года назад

    Are you teach advance Excel course

  • @SanaRao-p6x
    @SanaRao-p6x Год назад

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

  • @Rk-ik5lz
    @Rk-ik5lz 2 года назад

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

    • @sudhanshu522
      @sudhanshu522 2 года назад

      Bro setting m jake 1080p kro

  • @nomulanikhila4722
    @nomulanikhila4722 7 месяцев назад

    But how to calculate absent days in a month

  • @Amisha301
    @Amisha301 3 года назад

    Thanks sir🙏🙏

  • @theescanor8985
    @theescanor8985 2 года назад

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

  • @rajpanwar11
    @rajpanwar11 3 года назад

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

    • @SKRLearningPoint
      @SKRLearningPoint  3 года назад

      Format cell me ja kr date format select kr lo bs

  • @premprakash3339
    @premprakash3339 2 года назад

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

  • @shiwanisaw05
    @shiwanisaw05 4 года назад +1

    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 ?

  • @ImdadHussainHussain-gk6hn
    @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

  • @Seriously_Busy_in_Patna
    @Seriously_Busy_in_Patna 2 года назад

    Well Sir. is there any formula for making Calender ?

  • @sudhanshu522
    @sudhanshu522 2 года назад

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

    • @SKRLearningPoint
      @SKRLearningPoint  2 года назад

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

  • @dheerajphadatare5135
    @dheerajphadatare5135 3 года назад +2

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

  • @muhammadhusnain2258
    @muhammadhusnain2258 Год назад

    Sir g formula ko freez kasay kartay Hain please tell me

    • @SKRLearningPoint
      @SKRLearningPoint  Год назад

      Excel in Hindi- Absolute and Relative Cell/Range References #SkrLearningPoint
      ruclips.net/video/7PIxyWBVjgQ/видео.html

    • @SKRLearningPoint
      @SKRLearningPoint  Год назад

      Excel in Hindi- Mixed Cell References #SkrLearningPoint
      ruclips.net/video/9E23Lo6wV6E/видео.html

  • @RohitPatidarOffice
    @RohitPatidarOffice 2 года назад

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

  • @rishijain9540
    @rishijain9540 5 месяцев назад

    File is unable to download

  • @rajeevgosavi4514
    @rajeevgosavi4514 3 года назад

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

  • @parhladsharma
    @parhladsharma 3 года назад

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

  • @susamaaleya3305
    @susamaaleya3305 4 года назад +1

    Thank you sir

  • @Deependra1991
    @Deependra1991 4 года назад

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

  • @Its.my.pleasure
    @Its.my.pleasure 3 года назад

    Ye sare formulae excel 2007 me hai kya?

  • @shaiksufiya4927
    @shaiksufiya4927 4 года назад

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

  • @binaykumarnayak9114
    @binaykumarnayak9114 3 года назад

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

  • @shanurshaikh1173
    @shanurshaikh1173 4 года назад

    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

  • @kokitormmrj2320
    @kokitormmrj2320 Год назад

    Can you put the video in CC English please?

  • @ruchitajambhulkar8864
    @ruchitajambhulkar8864 3 года назад

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

  • @MehediHasan-rj9w
    @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

  • @iZacq
    @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

  • @somthingdiff2050
    @somthingdiff2050 2 года назад

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

  • @ExcelTricksentertainment
    @ExcelTricksentertainment 3 года назад

    Thanks

  • @netajibhosale3212
    @netajibhosale3212 4 года назад +1

    WELL TEACHING

  • @vivekkumari8292
    @vivekkumari8292 Месяц назад

    Ye semicolam kya

  • @Travelwithme0504
    @Travelwithme0504 3 года назад

    how to add next year with year() function.

  • @rajeshchoudhary2520
    @rajeshchoudhary2520 4 года назад

    Nice Video

  • @SAHIBSINGH-fk1uv
    @SAHIBSINGH-fk1uv 3 года назад

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

  • @ChillTime2409
    @ChillTime2409 Год назад

    Nice

  • @dnyanendra8138
    @dnyanendra8138 4 года назад

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

  • @dharmeshsingh8455
    @dharmeshsingh8455 11 месяцев назад

    Excel sheet unable to download

  • @sandeepgaur8920
    @sandeepgaur8920 2 года назад

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

  • @iyobosaedosa3874
    @iyobosaedosa3874 4 года назад

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

  • @rajeevgosavi4514
    @rajeevgosavi4514 3 года назад

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

  • @mohanpal13555
    @mohanpal13555 4 года назад

    Awesome

  • @lovejob-wz8hf
    @lovejob-wz8hf 2 года назад

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

  • @Sukoonbykrunal
    @Sukoonbykrunal 4 года назад

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

    • @SKRLearningPoint
      @SKRLearningPoint  4 года назад +1

      You can use Eomonth with networking days

    • @Sukoonbykrunal
      @Sukoonbykrunal 4 года назад

      @@SKRLearningPoint thank u

    • @SKRLearningPoint
      @SKRLearningPoint  4 года назад

      @@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]

  • @anshulchaturvedi7382
    @anshulchaturvedi7382 4 года назад

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

  • @railtechecr592
    @railtechecr592 2 года назад

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

  • @pratikpatade7844
    @pratikpatade7844 4 года назад

    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.

  • @pcommunication5817
    @pcommunication5817 2 года назад +1

    Workbook not opening

  • @muhammadzubair7188
    @muhammadzubair7188 3 года назад

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

  • @technofy
    @technofy 4 года назад

    how to calculate total 31 days month between two dates

    • @SKRLearningPoint
      @SKRLearningPoint  4 года назад

      Use networkingday and workingdays formulas.
      ruclips.net/video/2yf_EXRtYQM/видео.html

  • @taufiqbaroda2475
    @taufiqbaroda2475 4 года назад

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

  • @nenumovielover
    @nenumovielover 2 года назад

    Practice link send me sir in comment box

  • @Babita377
    @Babita377 Год назад

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

  • @u_have_2_know
    @u_have_2_know 3 года назад

    "Last day of Month" formula is not working 😕

  • @AbdulHakim-ns3px
    @AbdulHakim-ns3px Год назад

    Sound Problem

  • @NSMS57
    @NSMS57 4 года назад +1

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

    • @SKRLearningPoint
      @SKRLearningPoint  4 года назад

      Use TEXT function, It's very easy

    • @NSMS57
      @NSMS57 4 года назад

      @@SKRLearningPoint kindly provide the formula if possible, thanks

    • @SKRLearningPoint
      @SKRLearningPoint  4 года назад

      Share me your data with example
      info@skrlearningpoint.onmicrosoft.com

    • @NSMS57
      @NSMS57 4 года назад

      @@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
    @kumarshubham9811 4 года назад

    volume bilkul sutta k dala h

  • @pankajgirdhar2502
    @pankajgirdhar2502 4 года назад +1

    Awaaj bhoot slow ha

  • @armaanmalik278
    @armaanmalik278 4 года назад

    Not clear vision

  • @AnilYadav-ow6zk
    @AnilYadav-ow6zk Год назад

    Y

  • @hariprakashlodhi755
    @hariprakashlodhi755 2 года назад

    Plz call me help

  • @ashleyhenryfanclub6501
    @ashleyhenryfanclub6501 2 года назад

    Ghatiya explanation