Hey everyone, I've spent the past few days banging my head off the wall with this one.
What I need to do is take the recurring and completed into the equation. So essentially like this;
If reccuring is Yes, than the formula result should be On time.
The second part I need to work into it is,
If completed date is less than due date then show on time otherwise show late.
When I try to build it in I get too many arguments as I have way too many arguments. I imagine I can accomplish what I'm looking to do with And/or functions but I can't wrap my head around it.
=IF(B3="","", IF($I$1<=G3, "On Time", "LATE"))
This is the formula I am using to get the current result. B3 = date of entry in the tracker. I1 is the current date via today () and G3 is the due date field which is calculated by the date of entry + SAL (date of entry plus 14 days for low priority)
What I have so far is;
If B3 is blank then show a blank in the cell, else if current date is less than or equal to due date then show on time, otherwise show late.
This all works flawlessly, although I am sure that there is a better way to do it. My excel fu is fairly weak.
Any help would be greatly appreciated.
Here is a link to the sheet.
https://drive.google.com/file/d/0B5wwlj8ylu7rNkNGUHdzTlNlZV9rX1JKa1Q0ekNkYmpNZ3lz/view?usp=drivesdk
What I need to do is take the recurring and completed into the equation. So essentially like this;
If reccuring is Yes, than the formula result should be On time.
The second part I need to work into it is,
If completed date is less than due date then show on time otherwise show late.
When I try to build it in I get too many arguments as I have way too many arguments. I imagine I can accomplish what I'm looking to do with And/or functions but I can't wrap my head around it.
=IF(B3="","", IF($I$1<=G3, "On Time", "LATE"))
This is the formula I am using to get the current result. B3 = date of entry in the tracker. I1 is the current date via today () and G3 is the due date field which is calculated by the date of entry + SAL (date of entry plus 14 days for low priority)
What I have so far is;
If B3 is blank then show a blank in the cell, else if current date is less than or equal to due date then show on time, otherwise show late.
This all works flawlessly, although I am sure that there is a better way to do it. My excel fu is fairly weak.
Any help would be greatly appreciated.
Here is a link to the sheet.
https://drive.google.com/file/d/0B5wwlj8ylu7rNkNGUHdzTlNlZV9rX1JKa1Q0ekNkYmpNZ3lz/view?usp=drivesdk