View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rustyroo Rustyroo is offline
external usenet poster
 
Posts: 1
Default 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.