Hi Everyone

I am trying to set up a spreadsheet in Excel 2000 that allows me to input a
date that an item is requested (J4) and then keeps a record of the time
passed (L4) up to the present date until I input the date the request was
received(K4), eg


O
1
Todays Date

J K
L

4 Date Item Requested Date Item received
Length of Time

waiting for result

So what I want it to do is give me the days waiting between todays date and
J4 in L4 unless I enter the received date in K4 when I want it to give me the
difference between K4 and J4.

I hope this makes sense.

Yours

Garry