In column C (third column), enter this formula, making sure to format
the cell as GENERAL:
=(A1-B1)
This assumes both columns A and B are formatted as Date (mm/dd/yy)
Note however, that this returns 11 in your example, as there are 11
days from Sept. 20-Oct 1. If you want to know the number of days
excluding the due date, the formula would be:
=(A21-B21)-1 which returns 10 in your example.
with a due date of Jan 3, 06 and today Sept 20, 05: 104 is returned.
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=469253