Hi to all wizards again!

I have this problem that would really need your help.

I have cell A1 with a value of 4/3/2012 and cell B1 with a formula =TODAY()-A1

So, cell B1 there will continuously count the number of days with reference from cell A1

Now, I want a formula on cell C1 that if I enter the current date then cell B1 will stop counting.

Somebody please help.

Thanks.