Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|