Calculate Penalty Amount by Overdue Months and Days in Excel

This method is very useful for company to calculate penalty amount based on overdue amount and period. Debt collector and lawyer will find this tips useful too.
Download eBook: The 5 Magic to Master Business Data
👉 5-secrets-biz-...
Follow Me in Odyess
👉 odysee.com/@Ex...
Join Me in Odyess
👉 odysee.com/$/i...
Connect to me in LinkedIn
/ excelsifu
Like our FB
/ whyexcel

[@RESHMANAMPALLI]

Pls send me excel sheet

[@ExcelSifu]

@@RESHMANAMPALLI
You could recreate the file with ease. By doing so, you can polish your skill.
Hope this supports you in getting better in Excel.

[@venucita07]

Hi, thank you for the video! Do you have one that componds the insterest calculation daily? thank you!

[@ExcelSifu]

Hi, could you give me more details on this.
Is the rate fixed for daily calculation or ...?

[@ssdulau8376]

Hi Mr Tai. In my Excel, there is no 'Datedif'. What is other option I can use ? Thank you.

[@ExcelSifu]

It's a hidden function. You could type it as shown on the video.

[@aimimbarabanki9545]

Hello

[@ExcelSifu]

👍🏻