Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Due Dates/Submission Date

0

i am trying to create a condition for a table where if the due date is past, the date turns red, which i have achieved. I also have a submission date column, which i would like to be considered in the highlighting of the due date. So if the due date is 7/27/18 and today is 7/31/18, then the date would be highlighted in red if nothign was submitted, but if it was submitted on 7/27/18 then the due date doesn't get highlighted. and if it was submitted late, it is still highlighted red.

Answer
Discuss

Answers

0
Selected Answer

Try this formula:

=IF(AND(C1>A1,OR(NOT(B1<=A1),ISBLANK(B1))),TRUE,FALSE)

A1 = Due Date

B1 = Submission Date

C1 = Today

I probably made it too complex but it should do what you want.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login