Counting days

T

tinkertron

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
 
J

Jason Morin

=A1 + 5

where A1 contains the "receive documents" date.

HTH
Jason
Atlanta, GA
 
M

macropod

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
 
D

DaveShoe

Greetings:

I am unclear on what you are searching for, however I will give it
try:

If you are saying that you have 2 columns, each with a date and yo
want to know the difference between the two, you can use a simpl
subtraction formula.

if: a2=feb 3 and b2= jan 20
=a2-b2 gives you "14".

Be sure to format this last column as a number or general. You coul
achieve similar results if you need to add days to dates, in which i
would yield a new date.
=a2 + 5 gives "feb 8"

Good Luck.

Dav
 
Top