Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have a requirement to calculate the interest on the overdue amount for customers. The overdue days is calculated from the invoice date which is uploaded through an excel sheet.
I need to calculate the interest on number of days
For example : An sale which was made on 15-Jul-2010 is due. I need to calculate interest by identifying the overdue days
ie difference between 19-Aug-2010 and 15-jul-2010 and apply 10% interest p.a. on the invoice amount.
Can anyone help me out with a formula to get the overdue dates.
Regards,
Raghav
As dates are stored in days you can simply subtract the invoice date from current date to get number of days overdue
Steve
Hi,
if you are having both days then for calculating days you can simple subtract.
like: Overdueday=Date(Today())-Date(invoiceDate)
Regards,
Ravi
hi All,
Thanks for the suggestions. It was very helpful.
Regards,
Raghav