Date validation in a formula

S

Scott63304

How can I validate a cell contains a valid date before
using the value in a formula? For example: start_work_date
minus end_work_date = networkdays. Either date field can
have blanks, text or a valid date. If the field has blanks
or text, the formula returns a negative number
or "#value!". I would like to eliminate these results.

Suggestions?

Thanks
Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Testing a cell value for a specific weekday. 3
Data validation: want input restricted to date value or N/A 2
Validation of blank cells 3
Dragging a formula in a column 1
Validation on E-mail address 2
Project Time in a year formula 0
nested IF(OR Vlookup returning zero instead of value in target cel 7

Top