Reply to thread

Message: [QUOTE="John, post: 3252968"] I am working on a project to track parts ordered, shipped, and recieved. I am trying to calculate the number of days between the entries automatically. I have the following: d1=date aircraft grounded d2=date order generated d3=date part shipped d4=date unit recieved part d5=date aircraft back in service c1=compare d2-d1 c2=compare d3-d2 c3=compare d4-d3 c4=d5-d1, (total days aircraft grounded) my first comparision is the difference between date 2 and date 1;d2-d1=c1, but until i put in a date into d2 i get a large negative number. how can i get it to not compute the difference until both dates are entered? there may be as many as three or four days between the entries. is it possible to have the cell or line change color if the number of days exceeds four days? i have the same problem with all of the comparisions. there are occasions when an order will be cancelled prior to shipping and i need to enter "N/A" inot the cell. [/QUOTE]