Count day Enquiry

[pjlau]

I am using Excel 2003.
I have a worksheet with 4 columnS
Column A - count no of days vs Today date (use formula 1)
Column B - count no of days vs Completion Date - column D (use formula 2)
Column C - Start Date input by user
Column D - Completion Date input by user

Column A - TODAY()-C10-SUMPRODUCT((AB$10:AB$100>=C10)*(AB$10:AB$100<=TODAY())) WHERE AB$10:AB100 is a specific date to exclude

Column B - IF(D10="","",D10-C10-SUMPRODUCT((AB$10:AB$100>=C10)*(AB$10:AB$100<=D10))) WHERE AB$10:AB100 is a specific date to exclude

My question is how to stop column A "calculation" and count the no of days vs column D - completion date when it is input.

Thanks

[Mallycat]

You could add an if statement to your column a formula.

=if(column d cell is blank, then use your formula above, else put in a new formula that gives the permanent date you want to see after it is completed)

This is of course not the real formula, just pseudo code of what you need to do.

[pjlau]

Can you advise how to write this formaula. Thx

[Mallycat]

if you post a sample of the sheet, I will do it for you

[pjlau]

Anyone can help on that ,please?

[Mallycat]

Yes. Like I said if you post a sample sheet, I will help you. Click Reply to this thread, then click on the "go advanced" button in the bottom right corner, and attach a file using the paperclip button

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.