Counting days

T

tinkertron

It's really simply on what I want. I'll receive a case file, lets say I
have two columns. Lets say the file comes in on 05/05/05 and I place
this date in cell A1, and in the second column i want a date to be
automactly inserted into the second column by how many days it takes to
work the file. In my case it would be 5 days. So whats the formula that
I would place in A1 cell to have A2 to insert a date?
 
B

Biff

Hi!

If you enter a date in cell A1 put this formula in cell A2:

=A1+5

OR, to be more thorough, you would first test cell A1 to
make sure it has a date in it:

=IF(ISNUMBER(A1),A1+5,"")

This will leave cell A2 blank if a date hasn't been
entered into cell A1.

Biff
 
Top