Solved How can I add a Ignore Blank Cells to this Excel formula?

June 14, 2017 at 11:27:28
Specs: Windows 7
I have an online worksheet that people can fill out as the month progresses but needs to be submitted by a due date. I want to write a formula the identifies if the worksheet has been submitted on time but ignore the blank cells showing the worksheets still in progress. So I have a spreadsheet with a row for each worksheet in progress and Column A identifies the date the worksheet is submitted as complete, Cell AX1 identifies the due date, Column B identifies if the worksheet was submtted by the due date using this formula:
=IF(A5<=DATEVALUE("7/7/2017"), "On Time", "Late")

See More: How can I add a Ignore Blank Cells to this Excel formula?

Report •

#1
June 14, 2017 at 14:44:43
✔ Best Answer
re: "...but ignore the blank cells showing the worksheets still in progress"

I assume that you mean that you want the formula you posted to return "nothing" (blank cell) if A5 is empty. If that is correct, try this:

=IF(A5="","", IF(A5<=DATEVALUE("7/7/2017"), "On Time", "Late"))

However, I'm confused by your mention of "Cell AX1 identifies the due date"

I don't see AX1 used in the formula. Why did you mention that?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
June 14, 2017 at 16:18:09
Thank you, DerbyDad03 for your help. Your solution worked perfectly!

I've searched Google for this solution and tried many options found there but never found the option you suggested. Your solution is just what I needed. Thanks!

You are right in the end, I didn't use Cell AX1 for the date grab but had intended to.


Report •
Related Solutions


Ask Question