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?


DaveShoe Wrote:
> Greetings:
>
> I am unclear on what you are searching for, however I will give it a
> try:
>
> If you are saying that you have 2 columns, each with a date and you
> want to know the difference between the two, you can use a simple
> 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 could
> achieve similar results if you need to add days to dates, in which it
> would yield a new date.
> =a2 + 5 gives "feb 8"
>
> Good Luck.
>
> Dave
>
>
> --
> DaveShoe
> ------------------------------------------------------------------------
> DaveShoe's Profile: http://www.msusenet.com/member.php?userid=315
> View this thread: http://www.msusenet.com/t-1869397785


--
tinkertron