if cell is blank then calculate how many days?
Hi,
Here is another way to write it:
=IF(B2,"",TODAY()-A2)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Machel" wrote:
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!
|