Formula Exceptions

Hello,

I am creating Project Tracker Spreadsheet. I have a column that will track how long it took for the project to be completed, pulling in information from a "Start Date" Column and an "End Date" Column. However if no end date is entered (but a start date is entered) I would like for the cell to read "In Progress", if no start date is entered I would like for the cell to remain blank, and if both start and end dates are entered to calculate the number of days. Can anyone help me out with this?

Assume Column A has the start date and Column B has the end date... The formula would look like this for row 2. Just copy down for the rows below that.

Formula:

Please Login or Register  to view this content.

Thanks, Guys. That fixed me right up.