Count days in between or if not entered till TODAY
Thank you.
"T. Valko" wrote:
Try it like this:
=IF(B1="-",TODAY(),B1)-A1
Or:
=IF(COUNT(B1),B1,TODAY())-A1
--
Biff
Microsoft Excel MVP
"murkaboris" wrote in message
...
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
"Jim Thomlinson" wrote:
=if(B1 = "", Today(), B1) - A1
--
HTH...
Jim Thomlinson
"murkaboris" wrote:
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
|