Try this:

=IF(AND(COUNT(A1),B1=""),TODAY()-A1,"")

--
Biff
Microsoft Excel MVP


"Machel" wrote in message
...
What would the formula in C column be if I want to know how many days from
the A column date to today - if the B column is blank?

A B C
Start Date Return to Work Date Out How Many Days?
06/29/2009
01/11/2009 02/02/2009

Thank you for your help!