Count days in between or if not entered till TODAY

[murkaboris]

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

 

[Jim Thomlinson]

=if(B1 = "", Today(), B1) - A1

 

[murkaboris]

Hello Jim:

It didn't work, still getting #VALUE! error when in the column "B" I have
the "-" value for a no date.
Please advise.
Thx
Monika

 

[T. Valko]

Try this:

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

Format as General or Number

 

[murkaboris]

Jim:

sorry -- it actually works if I remove the "-" symbol for the cells that
don't have a date yet. Is there a way to make the formula works while keeping
the symbol in the cell -- didn't want to have blank cells but if this is the
only way I'll keep it that way.

Thanks for your help.
Monika

 

[T. Valko]

Try it like this:

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

Or:

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

 

[Per Jessen]

Hi

We use IF to check if Current/Complete is empty, then decide whitch formula
to use:

=IF(B12<>"",B12-A12,TODAY()-A12)

Regards,
Per

 

[murkaboris]

Thank you Per
Monika

Hi

We use IF to check if Current/Complete is empty, then decide whitch formula
to use:

=IF(B12<>"",B12-A12,TODAY()-A12)

Regards,
Per

 

[murkaboris]

Thank you.

Try it like this:

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

Or:

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

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you.