This is a simple subtraction of one date from the other, with the result
formatted as general or numeric - Excel will give you a date format for the
answer by default.

Cheers


"tinkertron" wrote in message
...

I assign work to fellow employees. Most of the have certain amount of
days to complete the assignment. I want to enter a date and then
another date is genarated and placed in another cell. for exsample:

Recieved documents on 10/5/05 and the document packet must be completed
by 10/10/05. As you can see I gave my employee 5 days to complete the
document packet. What formula will I need to uses this? Thanks


--
tinkertron