| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Due Dates
Is there a formula in Excel that allows you to calculate how many days past
due a payment is? |
|
#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 "Karen" wrote in message ... Is there a formula in Excel that allows you to calculate how many days past due a payment is? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
| I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
Linear Mode
