Try this:

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

Format as General or Number

--
Biff
Microsoft Excel MVP


"murkaboris" wrote in message
...
Hello:

I'm trying to count days between two columns, it works fine till the
"Current" column doesn't have an entry bcs an item hasn't been completed.
In that case I want to count the days till "TODAY" since its still
counting...any help?
Do I need to use an IF with "Error" to accomplish this?

i.e.

Original Date Current/Completion Date
06/08/09 08/17/09
09/03/09 -
04/23/08 02/08/09

Simple formula works if both columns are populated but in a case like the
row two above when the current day is not populated yet I'm getting error.

Please help.
Thank you.

Monika