Number of Days Count/Calculation?

I have a spreadsheet where I want to calculate the difference between Column A: Date Opened, and Column B: Due Date.

My idea is that Column C would subtract the date in Column B from the date in Column A to then display an integer number.

If the number in Column C is a negative number, then that task for the project is still ok and on-time. But, if the number is a positive number, then that would be a display of how many days past the Due Date that task is.

Can anyone help me figure out the formula for this?

Thanks VBA.

I pasted in your formula, but I got an error. It is:

The formula you typed contains an error.

• For information about fixing common formula problems, click Help.
• To get assistance in entering a function, click OK, then click Function on the Insert menu.
• If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (').

Awesome!

Thanks. Once I adjusted the formula to reference the correct columns and rows, (Column E instead of B, and Column D instead of A, and it began on row 2 with row 1 being column headers), it worked great!

Thanks.

Wait...

I thought it was working, but it's not quite meeting my needs, and it is due to the fact that I failed to submit all of the elements for the spreadsheet.

Column A: Date Opened
Column B: Due Date
Column C: Date Closed

Column D: Calculates how long it took to do the task. If C is less than B, then it was "On time". If C is greater than B, then it is "Past Due".

Can anyone help? VBA?

Excellent.

Thanks VBA. With your help I was able to improve my spreadsheet so it displays much better "human readable" data.

Thanks again,
Jon