Excel 2000 - show billable days

Thanks EdMac!

The 1st formula provides a static date of " 2/29/00 " which is ok I suppose.

The second formula provides a result of " 39814 " which I think is some sort of date series (format) used by Excel. The problem with the readout is that it adds erroneously to the total. If there is no data in the row, then the cell should read blank, true? However, when I type in the "Placement" date in the proceeding column, the billable days column calculates the result correctly. - correct calculation, incorrect empty readout.

Is there an argument we can add to to suppress the output if the cell is blank?

Cells must be formatted as date

Both formulae should provide blank if no input - they did when I tested it

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save