Thanks Bill,
for some reason I could not get the "sometimes" columm to adjust correctly
but thank you for your input. Your outcome could come in handy for me on
another worksheet.
Greetings from Michigan

"Bill Kuunders" wrote:

one way

A1 is the constant date
B1 is normally used
C1 is sometimes blank

enter in D1

=IF(C1<0,C1-A1,B1-A1)


--
Greetings from New Zealand

"dhealy" wrote in message
...
I have 3 columns with dates in them with one column being the constant. I
need to find the number of days between the constant date and one column
if
the other column is blank, if there is a date in the 3rd column then I
need
to use that date with the constant. Help...