Due Dates
Is there a formula in Excel that allows you to calculate how many days past
due a payment is? |
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 "Karen" wrote in message ... Is there a formula in Excel that allows you to calculate how many days past due a payment is? |
Assuming the date is in A1
=TODAY()-A1 and format as General -- HTH RP (remove nothere from the email address if mailing direct) "Karen" wrote in message ... Is there a formula in Excel that allows you to calculate how many days past due a payment is? |
All times are GMT +1. The time now is 02:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com