Excel All Date Formulas and Functions | Excel Formulas | Excel Formula Tutorial

Поділитися
Вставка
  • Опубліковано 21 жов 2024

КОМЕНТАРІ • 107

  • @nishashakya4913
    @nishashakya4913 2 роки тому +3

    Sir you are to good ...you are best teacher for computer

  • @cutechinfotamil
    @cutechinfotamil 2 роки тому +3

    Advance congratulations for 1 million subscribers. Your videos are very useful for many people. All the best.

  • @RohitSingh-UP_WALE
    @RohitSingh-UP_WALE 2 роки тому +1

    Super video sir
    Formula videos ki hi jarurat hai ...nice sir

  • @SathiSupport
    @SathiSupport 2 роки тому +6

    Most Useful Video Sir Tnk for update Keep it up and God Less You. We are happpy to Part of Your YT Family and Growing our Knowdlage free.

  • @klrahul1304
    @klrahul1304 Рік тому +2

    गुरु जी। मुझे ये क्लास बहुत ही अच्छी लगी ❤

  • @missnayabchannel9895
    @missnayabchannel9895 2 роки тому +1

    Superrr से भी ऊपर सर, Wonderfull

  • @mantoshkumarprajapati7802
    @mantoshkumarprajapati7802 Рік тому +3

    Very very thanks sir 🙏🙏🙏💐💐👌👌

  • @NavneetKumar-wf4pl
    @NavneetKumar-wf4pl Рік тому +2

    Very nice sir.............

  • @lakpagelicreation5085
    @lakpagelicreation5085 2 роки тому +2

    well job thanks for your information

  • @divyarastogi3630
    @divyarastogi3630 Рік тому +2

    Sir, one request please..... Assignment bhi kra dijiye all topics per.... Company mai job k liye help kre....
    New Playlist bna kr....

  • @PrinzZIsback
    @PrinzZIsback 2 роки тому +1

    Thank you so much.. it was very helpful

  • @JitendraKumar-cd9qg
    @JitendraKumar-cd9qg Рік тому +2

    Thanks a lot sir

  • @nurulhaque89
    @nurulhaque89 8 місяців тому +2

    Very important Video

  • @banjaratravels9107
    @banjaratravels9107 2 роки тому +2

    brother ek complete video for accounting ke liye banao like, invoicing, client and vendor ledger, banking, payment voucher, stock management and employees entry with salary package and advance salary etc

  • @rukhsarsheikh4735
    @rukhsarsheikh4735 Рік тому +2

    Thanks alotttttt❤❤❤❤❤❤❤❤❤❤❤

  • @miniatreya8795
    @miniatreya8795 Рік тому +1

    Full support ...good knowledge

  • @devangthakkar6847
    @devangthakkar6847 2 роки тому +1

    Superb sir - thanks for updates

  • @Altaf_Alam
    @Altaf_Alam 2 роки тому +2

    Superb sir 😀😃

  • @saurabhsrivastava2520
    @saurabhsrivastava2520 2 роки тому +2

    Hello Deepak Bhai
    Bhai me retail sector me job karta hu to plz kuchh retail operations se related bhi video share kariye jaise business review sheet like WTD MTD YTD report staff productivity report tips and last Ebitda bhi samjha dijiye apni language me
    Thank you 🙏

  • @ManoMani-r1y
    @ManoMani-r1y 4 місяці тому +1

    Thank you sir ap bhot acha parahtay ho

  • @himi1509
    @himi1509 2 роки тому +1

    Thanks Sir

  • @lakshmanansh7983
    @lakshmanansh7983 2 роки тому

    Sir esi tarah all series by formula ka videos jajur upload kare

  • @Nirajkumar23-6
    @Nirajkumar23-6 2 роки тому +2

    Tally ERP9 A to z ka video banao please

  • @WajahatAli12145
    @WajahatAli12145 2 роки тому

    Beautiful video

  • @kawmalmustafa1537
    @kawmalmustafa1537 2 роки тому

    Thanks brother

  • @abhijeetganguly8764
    @abhijeetganguly8764 2 роки тому +1

    Great

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому +2

    Sir tally ka video bnaiye

  • @rajpatel4596
    @rajpatel4596 8 місяців тому +1

    Good👍👍👍👍❤

  • @abdulqadirkhattak7661
    @abdulqadirkhattak7661 Рік тому

    Helpful

  • @mohammadghazanfarraza7814
    @mohammadghazanfarraza7814 10 днів тому +1

    Sir Mujhe Date k Bate Me Ek Vedio Bnaye De plz...
    Excelsheet Me Mujhe 5 Years K Date Chahiye... 1 to 31 Days Monthly Wise....
    Fir jb Mai Monthly Choose Kru Uss Month k 1 to 31 Days Aagay...
    Jb 12th Mother Pure Hojay To Firr Sirf Mai Year Chang kru...Uske Baad ussii Year ke Date Month Statr Hojay....
    Filter Laga kr change Krta Rhu... Years/Month/Date...
    Plz Sir Ek Vedio Bnaye De Plz....

  • @rheapeter9709
    @rheapeter9709 Рік тому +1

    Thank you sir!!

  • @akashjain7672
    @akashjain7672 2 роки тому +1

    Hello sir in workingdays. Intl( ) there have some issues....... Please check..... You did not freeze the holidays cell so it gets moving.... To downword

  • @chshahzad3172
    @chshahzad3172 2 роки тому +1

    Sir, plz tell me How we add formula function vlookup and concatenate in a single column.

  • @vinayak4898
    @vinayak4898 2 роки тому

    Sir thanks for this video.. per kya aap koi freelance platform bata sakte hai ? Jaha apan apni excel skills ko use karke EARNING kar sake . Please make video on this topic

  • @theactivetraderspointfo4279
    @theactivetraderspointfo4279 2 роки тому +1

    जय हिंद दोस्तों 🇮🇳🇮🇳🇮🇳
    .
    .
    Thank you so much sir ❤️🙏

  • @ujjalghosh1719
    @ujjalghosh1719 2 роки тому +1

    Try "Y" for years, "YM" for months & "MD" for days in the datedif function. You will get correct answer.

  • @rajadey1552
    @rajadey1552 2 роки тому +1

    Bhaiya data to data matching wala ek video banaye plz. 🙏
    Aap ko pehle v request kiya tha 🙏

  • @dynamic_duo157
    @dynamic_duo157 2 роки тому +1

    Sir please make a video to repeat a month twice which is selected from drop-down list
    And remaining months should in continuation
    Eg: If I select Nov month from drop-down list
    Then output should be as follows:
    Jan
    Feb
    Mar
    Apr
    May
    Jun
    Jul
    Aug
    Sep
    Oct
    Nov
    Nov
    Dec
    In the output Nov repeated twice,whereas remaining months only once

  • @arunkhanal7208
    @arunkhanal7208 2 роки тому +1

    Deepak ji,
    In the First 3 Formulas you have forgotten to press the function key F4 for the range of Holidays.

  • @rakeshchandaliya5196
    @rakeshchandaliya5196 2 роки тому +1

  • @Hariom0035
    @Hariom0035 7 місяців тому

    Supar

  • @sachanamit3234
    @sachanamit3234 2 роки тому

    Banks me 2nd @ 4th saturdays bnd rehta hai to us case me workday formula kaise lagega??

  • @maazeez11
    @maazeez11 11 місяців тому +1

    Week year is coming as 2nd week but thats 1st week na?

  • @babamishra2808
    @babamishra2808 Рік тому +2

    Intl wala formula 2007 wale me kaam nahi kartha hai kya

  • @govindpfsolutions
    @govindpfsolutions 2 роки тому

    1st viewers

  • @vikasjangra3563
    @vikasjangra3563 2 роки тому

    sir datewise multiple entry vlookup se kase dakhe pls bataye sir

  • @nehalshah9901
    @nehalshah9901 2 роки тому +2

    Isme holiday ka cell reference fix nahi kiya islie task 2,3,4,5 mein end date galat aa raha hai.

  • @atifmehmood1985
    @atifmehmood1985 2 роки тому +1

    Hello sir
    I am Atif. I don't know whether you will reply me or not.
    But for hope to get reply from your side I leave a question.
    Whenever I create general mark sheet for the class and apply the formula of ranking I face a problem that if 2 students get same position i.e 2nd in the class then the next position is ranked 4th instead of 3rd. Please help & guide to resolve this issue.
    I request you share me personally the link of your that video.
    Thanks in advance

    • @ITCE2018
      @ITCE2018 Рік тому

      Have you got the answer or can help you

    • @rjmeena01
      @rjmeena01 11 місяців тому

      Sir muje do date ke beech me 8 Tarik kitne baar aa rhi h uska formula kya hoga ..

    • @atifmehmood1985
      @atifmehmood1985 11 місяців тому

      @@ITCE2018 not

    • @atifmehmood1985
      @atifmehmood1985 11 місяців тому

      @@ITCE2018 ur help will be guidance for me

  • @jitendrasingh-tl3bk
    @jitendrasingh-tl3bk Рік тому

    year month day se date kaise nikalenge sir

  • @shanuthakur4494
    @shanuthakur4494 Місяць тому

    Sir holiday ka na lgana ho to kaise work day kaise kare

  • @ndgroupofemitrachomu
    @ndgroupofemitrachomu 2 роки тому

    Sir me aapke pass sikhna chahta hu

  • @apnacollageadda
    @apnacollageadda 6 місяців тому +1

    Holiday ko fredge nhi karna h kya

  • @sonalimahuabasiceducation.1809
    @sonalimahuabasiceducation.1809 2 роки тому

    Paint 🎨 ka bataey

  • @jahidali1314
    @jahidali1314 2 роки тому +1

    SIR ISKA NOTES KAISE LIKHE

  • @noormuhammadghaffari3672
    @noormuhammadghaffari3672 2 роки тому +2

    Sir mein pakisatan sa hu ap sa contact karna hein kasy karoo
    Plz

  • @HumanaazSiddiqui
    @HumanaazSiddiqui Рік тому +1

    Sir intl ka mtl kiya h

  • @qazijunaid4039
    @qazijunaid4039 2 роки тому

    Sir excel ce thermal print kise karen gee

  • @himi1509
    @himi1509 2 роки тому +1

    Please Upload Insert Tab of Excel
    It is pending

  • @ManoMani-r1y
    @ManoMani-r1y 3 місяці тому +1

    Or formulas batain ha
    ❤😢

  • @vishalvazurkar500
    @vishalvazurkar500 Рік тому

    Side holidays kahase liya aapne sir

  • @ashrafulbhuiyan4458
    @ashrafulbhuiyan4458 2 роки тому

    महोदय, आप बार को पुराना कैसे कर सकते हैं?

  • @archisingh9241
    @archisingh9241 2 роки тому

    Sir excel me koi yesa formula jaise (adca) likhe to uska full form aa jaye pless bataiye 🙋‍♀️🙋‍♀️🙋‍♀️🙏🙏🙏🙏🙏🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳🇮🇳👈👈👈👈👈👈👍👍👍👍

    • @archisingh9241
      @archisingh9241 2 роки тому

      @Pro All Rounder iska koi video h 🙏🙏🙏🙏🙋‍♀️🤗

  • @saurabhmehta5533
    @saurabhmehta5533 2 роки тому

    अगर एक्सेल की किसी फाइल में किसी कॉलम में कोई भी फॉर्मूला काम न करे तो तो फॉर्मूला लगाने के लिए क्या करे

  • @Nirajkumar23-6
    @Nirajkumar23-6 2 роки тому +4

    Tally ka 1 bhi video uploads nhi h

  • @hariomsingh327
    @hariomsingh327 2 роки тому

    Cut ki jagah copy ho raha hai excel me aisa kyu ho raha hai aur solution kya hai sir please bataiye

  • @sellaigopal3139
    @sellaigopal3139 2 роки тому +1

    Sir
    I need age calculator formula between two date
    Total year month days
    Ie. 19/09/2018 to today
    3 years 8 months 15 days

    • @gaganwadhwafreelancer
      @gaganwadhwafreelancer 2 роки тому

      Brother this Video will be helpful ua-cam.com/users/shortsZzfsUyzr02o?feature=share

  • @arunkhanal7208
    @arunkhanal7208 2 роки тому

    Deepak ji,
    You have shown three things only viz., total year, total month or total days separately using...
    DATEDIF
    You have not illustrated this way
    year month days
    like someone's today's age may be like
    56 year 3 months 5 days

    • @gaganwadhwafreelancer
      @gaganwadhwafreelancer 2 роки тому

      HERE IS YOUR Result ua-cam.com/users/shortsZzfsUyzr02o?feature=share

    • @gaganwadhwafreelancer
      @gaganwadhwafreelancer 2 роки тому

      WE CAN USE ALL THREE FORMULAS COMBINE THEM USING CONCETINATE FORMULA

  • @bijoydas3662
    @bijoydas3662 Рік тому

    kaise due date nikal na hai

  • @akashpandey1965
    @akashpandey1965 2 роки тому

    It's urgent

  • @chshahzad3172
    @chshahzad3172 2 роки тому

    Hello

  • @rajeebjr9045
    @rajeebjr9045 2 роки тому

    Sir aap ki contact no mil sakta he.

  • @aliraza910
    @aliraza910 2 роки тому +1

    How I can contact you

  • @mkraj6312
    @mkraj6312 2 роки тому

    Sir apke contact no share karna

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye

  • @AnkitMishra-ts2gw
    @AnkitMishra-ts2gw 2 роки тому

    Sir tally ka video bnaiye