View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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!