#learningcenter #Expirydate #ExcelTraining #advanceExcel In this excel tutorial you will learn how to calculate Invoice payment due date and Expiry date of Medicine in excel by learning center In Urdu/Hindi
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
@@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
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🙏🙏
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
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
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