Hi
Please help me with a fomula to calculate the "No of days' for Column C (the difference between column A and B) if column B is blank.
Thank You
Nancy
Hi
Please help me with a fomula to calculate the "No of days' for Column C (the difference between column A and B) if column B is blank.
Thank You
Nancy
sorry the number of days to when,?
maybe this
=IF(B3="","",B3-A3+1)
or this
=IF(B3="",TODAY()-A3+1,B3-A3+1)
Last edited by martindwilson; 10-06-2012 at 04:37 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi
C3=B3-A3
In the instance, C3=1
C5=B5-A5
C5 should be 3
Pl assist.
Thanks
try this
=IF(B3="",1,B3-A3+1)
copy down
=if(b3="",1,b3-a3+1)
Hi
Formula:Please Login or Register to view this content.
I don't how you get 1 from B3-A3!
Wow... "=if(b3="",1,b3-a3+1) " solve my problem.
However, after I copy down the formula and if B8 & A8 are blank cells (no data yet), it also reflect "1".
How can it reflect "0".
Regards
then it must be
=if(b3="",1,if((a3="")*(b3=""),0,b3-a3+1))
Last edited by dwint; 10-06-2012 at 05:38 AM.
Sorry, it cant work.
Regards
=if(a3="","",if(b3="",1,b3-a3+1))
Thanks. But after I add another column, the adjacent formula cannot work.
Please help.
Regards.
Book1-1.xlsx
=if(a3="",0,if(b3="",1,b3-a3+1))
Solved. Thanks.
I really appreciate your great help.
Regards
Nancy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks