calculating number of days

[raghavsurya]

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

[#2]

As dates are stored in days you can simply subtract the invoice date from current date to get number of days overdue

Steve

[#3]

Hi,

if you are having both days then for calculating days you can simple subtract.

like: Overdueday=Date(Today())-Date(invoiceDate)

Regards,

Ravi

[raghavsurya]

hi All,

Thanks for the suggestions. It was very helpful.

Regards,

Raghav