Is there a formula in Excel that allows you to calculate how many days past due a payment is?
K Karen Mar 13, 2005 #1 Is there a formula in Excel that allows you to calculate how many days past due a payment is?
J JulieD Mar 13, 2005 #2 Hi Karen with your due date in A1, formula for number of days past due in B1 =TODAY()-A1 formatted to a number (format / cells - number) Cheers JulieD
Hi Karen with your due date in A1, formula for number of days past due in B1 =TODAY()-A1 formatted to a number (format / cells - number) Cheers JulieD
B Bob Phillips Mar 13, 2005 #3 Assuming the date is in A1 =TODAY()-A1 and format as General -- HTH RP (remove nothere from the email address if mailing direct)
Assuming the date is in A1 =TODAY()-A1 and format as General -- HTH RP (remove nothere from the email address if mailing direct)
