Calculate Invoice Payment due date" and "Expiry date of Medicine" in excel by learning center

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

КОМЕНТАРІ • 42

  • @biswajitkaran89
    @biswajitkaran89 3 роки тому +1

    Amazing and very very informative.

  • @surajrawat6807
    @surajrawat6807 3 роки тому +1

    Bot bot thanks sir apka 👏

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

    Thank you sir!!

  • @saimakhan8316
    @saimakhan8316 3 роки тому +1

    Thanks

  • @surajrawat6807
    @surajrawat6807 3 роки тому

    Jruri baat hai

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

    Nice sir

  • @SharifulIslam-rr2eb
    @SharifulIslam-rr2eb 3 роки тому +1

    Ek aisa video bnao jo mere system ka dete se automatic expire find out ho jaiye

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

    Sir agar days left main humne formulla laga ke expired show karva diya aur status main bi humne same expired show karvana hai toh kya likhna padega

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

      write the same formula,but write Expiry instead of short expiry, you can change the days as you wish

  • @nobertdavid6112
    @nobertdavid6112 9 місяців тому

    Expires on column showing value, how to change that value to expire date

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

    Sir kya hum isme students ki fee due pta lga skte h..jaise koi student 2 ko aaya..koi 5 ko...sbki due date alag hogi..plz wo btaye

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

      yes you can put separate due date

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

      ua-cam.com/video/7vp6rMuLSa8/v-deo.html

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

      @@learningcenterHD sir for example bill aaj bna....to uspe mujhe due date months m nhi lgani...days m lgani h...wo kaise lgegi sir..uska formula excel m

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

      Sir plz reply..mujhe koi cheez 45 days k baad due krni h...dates kaise lgegi sir

  • @mechdice1183
    @mechdice1183 3 роки тому +1

    In the column of months to pay how to use it as days to pay. I want to use days instead of months. Please help

  • @ankitshukla1069
    @ankitshukla1069 3 роки тому

    Sir if I want to use more name in entry type then how to get last invoice number please tell the formula

  • @surajrawat6807
    @surajrawat6807 3 роки тому

    Sir apse baat krni hai plzz sir 👏👏

  • @fragrenceful
    @fragrenceful 3 роки тому

    Formula should be expiring within days or month or year.hosake to yeh formula show kijiye.itis important to us

    • @learningcenterHD
      @learningcenterHD  3 роки тому

      click on the formula it will be show at the top in the formula bar, or simply double click it.

  • @Hulana-i2j
    @Hulana-i2j Рік тому

    Can you please use English next time please 🙏 😢 we being left behind

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

  • @kashif007-c4j
    @kashif007-c4j 2 роки тому

    brother main cable ka kam kar karta hon mere pass 500 se zayda connection han, to mene in ko excel ko set kar raha hon mujhe asa formula chiahiye jis se mujhe ye pata chal jaye un 500 me se kis ne mujhe is maa bil diya hai or kis ne nhi diya

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

      hi are you there . i am just give you solution

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

      in My channel there is a number of Account Receivable format. which includes paid and outstanding customer list, fully automatic. just go to my channel home page(click on Chanel name) write in search box

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

      just watch this videos studio.ua-cam.com/users/videogDFMboZRoGI/edit

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

      studio.ua-cam.com/users/videoa81mHBrKV3E/edit

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

      studio.ua-cam.com/users/videouzDAYkwhjlY/edit

  • @yogis5740
    @yogis5740 3 роки тому

    02/07/2018 ka due date 3 months bad 01/10/2018 karna h kese hoga

    • @learningcenterHD
      @learningcenterHD  3 роки тому

      in Invoice date write 2/07/2018 and in"month to pay date" write 01/10/2018

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

    Sir, can we find Near expiry date on the basis of Only month and year?? Like " March 22 to Jan 23 = 11 months" to calculate this which formula we have to apply here??? If possible please reply me🙏🙏

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

      OK i will give you the solution soon .

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

      For Remaining Months instead of Days write a formula OR Create separate column with heading "remaining Months". in 1st Cell write a Formula DATEDIF(A4,C4,"M"). create another column with heading "Remaining Years" Here in 1st cell write formula DATEDIF(A4,C4,"Y"). try these .if still the problem persist.inform me

  • @yogis5740
    @yogis5740 3 роки тому

    Ek din pehle due date dikhani h to

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

    Thanks