@@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 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
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
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
Amazing and very very informative.
Bot bot thanks sir apka 👏
Thank you sir!!
Thanks
Jruri baat hai
Nice sir
Thanks and welcome
Ek aisa video bnao jo mere system ka dete se automatic expire find out ho jaiye
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
write the same formula,but write Expiry instead of short expiry, you can change the days as you wish
Expires on column showing value, how to change that value to expire date
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
yes you can put separate due date
ua-cam.com/video/7vp6rMuLSa8/v-deo.html
@@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 plz reply..mujhe koi cheez 45 days k baad due krni h...dates kaise lgegi sir
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
Sir if I want to use more name in entry type then how to get last invoice number please tell the formula
Sir apse baat krni hai plzz sir 👏👏
Formula should be expiring within days or month or year.hosake to yeh formula show kijiye.itis important to us
click on the formula it will be show at the top in the formula bar, or simply double click it.
Can you please use English next time please 🙏 😢 we being left behind
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
please come on whatsapp +923144886604
@@learningcenterHD ok
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
hi are you there . i am just give you solution
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
just watch this videos studio.ua-cam.com/users/videogDFMboZRoGI/edit
studio.ua-cam.com/users/videoa81mHBrKV3E/edit
studio.ua-cam.com/users/videouzDAYkwhjlY/edit
02/07/2018 ka due date 3 months bad 01/10/2018 karna h kese hoga
in Invoice date write 2/07/2018 and in"month to pay date" write 01/10/2018
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🙏🙏
OK i will give you the solution soon .
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
Ek din pehle due date dikhani h to
write one day before the due date
Thanks
Welcome