What formula do I need?
 

Ok I need to find out how long it takes our customers to pay an invoice, i
need to know if its xx days early or xx days late.

Column B has the invoice date
Column C has payment terms - usually 30 days end of month
Column D has payment date was received
Column E would have my answer in it either as -xx for days early or just xx
for days late.

What formula do I need?
 

Hi,

I assume you are saying you expect payment within 30 days from the end of
the invoicing month. If so:-

=(EOMONTH(B2,0)+C2)-D2


Format as general. A negative value would indicate late payment.
If you get a #NAME error then
Tools|Addins
check the analysis toolpak

Mike

"Rustyroo" wrote:

Ok I need to find out how long it takes our customers to pay an invoice, i
need to know if its xx days early or xx days late.

Column B has the invoice date
Column C has payment terms - usually 30 days end of month
Column D has payment date was received
Column E would have my answer in it either as -xx for days early or just xx
for days late.

What formula do I need?
 

Hi

Assuming you are working strictly on the dates and not the end of the month,
the formula would be

=B1+C1-D1




If this helps click the Yes button.
--
Thanks,
Shane Devenshire


"Rustyroo" wrote:

Ok I need to find out how long it takes our customers to pay an invoice, i
need to know if its xx days early or xx days late.

Column B has the invoice date
Column C has payment terms - usually 30 days end of month
Column D has payment date was received
Column E would have my answer in it either as -xx for days early or just xx
for days late.

What formula do I need?
 

Sorry,

I see you want days early to be negative, and days late positive, change to
formula to read

=D1-B1-C1
--
Thanks,
Shane Devenshire


"Rustyroo" wrote:

Ok I need to find out how long it takes our customers to pay an invoice, i
need to know if its xx days early or xx days late.

Column B has the invoice date
Column C has payment terms - usually 30 days end of month
Column D has payment date was received
Column E would have my answer in it either as -xx for days early or just xx
for days late.