Solved How do I add an Ignore blank cells formula to this?

June 14, 2017 at 09:49:05
Specs: Windows 7

I have an online worksheet that employees can begin to build the info in and submit by a due date. I want to build a formula that identifies wether the sheet was submitted on time, so Column A holds the date the worksheet was submitted, Cell AX1 holds the due date. Column B holds the "On Time" verification formula, =IF(A4<=DATEVALUE("7/7/2017"), "On Time", "Late"). I need help adding an "Ignore if date cell is blank" formula to my On Time verification formula.

See More: How do I add an Ignore blank cells formula to this?

Report •

June 15, 2017 at 06:20:52
✔ Best Answer
Something like this:

=IF($AX$1="","Ignore",IF(A1<=$AX$1, "On Time", "Late"))

and Excel questions are best asked in the Office Software forum.


message edited by mmcconaghy

Report •

June 15, 2017 at 06:30:44
Thanks Mike. I do realize I posted the question in the wrong forum and tried to delete and re-submit in the proper location. Thanks for the solution, I will give your suggestion a try. A solution submitted earlier worked perfectly, but you never know when the situation will arise that another option is neccessary too. Thanks again for your reply and for reading past my typos!

Report •
Related Solutions

Ask Question