Assume today's date if blank

I have a tracking sheet where rows represent properties and columns represent certificates issued against properties. The date on which the certificate is received is entered into the cells.

For example:

Please Login or Register  to view this content.

In the third column I would like to show the days between the certificate issue dates, which is easy (B3-B2). However, if the second certificate date is blank (as is the case with property 35), I want the days to be calculated as if the second certificate date were today's date. So because today is 10-Oct-2007, the number of days would be 4 since 06-Oct-2007.

How could I achieve this?

Many thanks,

GDI

I'm assuming you mean C2-B2. You could use

=IF(C2,C2,TODAY())-B2

Wow, fast response!

Sorry, I got my rows and columns mixed up. You're right, I meant C2-B2.

Thanks this is excellent, both solutions worked for my case. I understood the first (why didn't I think of that?!), but I'm not sure how the second works.

The way I read it, this means: If C2 = C2, use C2's value, if not, use TODAY. Or how is it read logically?

Cheers,

GDI

=IF(C2

returns TRUE if C2 is not blank or zero. it's perhaps more transparent to use

=IF(C2>0,C2,TODAY())-B2

I see, understood. Many thanks for your help!