Thanks for the solutions! They all worked well! I appreciate the help!

"Red" wrote:

Hi Marge.

Yes this can be done; a number of different ways actually. You can use an IF
statement in cell C3 that says something like this:

=IF(B4=0,(Today()-A4),B4-A4) then drag down for as many rows as you need.

Hope this helps.
--
Just a fellow Excel user here to help when I can.....


"Marge" wrote:

I know how to do this in Access, but I'm stumped with Excel.

I have columns for project start date, project complete date and days in
process. If the project complete date is null, I want a return of
NOW()-project start date.

A B C
project start project completed days in process
7/1/2009 8/1/2009 B3-A3

Can this be done in Excel?