Glad to hear it worked. Sometimes while digging deep, you can make your solution more complicated than needed (I do it all the time )
ajamess, not sure how it is that easy but it works and Thank You. I'm not really understanding the logic, if you have time could you please walk me through it?
No problem, I'll try to explain the logic in words (I'm not as good at this as numbers and code, so bare with me!)
This first part just checks if B2 is "", or blank. (I guess you could do isblank I believe the command is, I just have a habit of using ""). If it is blank, the output is 0.
Code:
...., if(C2="",Today(),c2)...
If B2 is not blank, it moves on to this next IF. The next two options are, if C2 is also blank, we're going to want, Today's date minus B2's date. If C2 isn't blank, we want to subtract B2 from C2. So we're either going to do Today -B2, or C2-B2. So this If statement, determines the first part of that. Say in
The if decides if x is Today(), or C2.
Sorry if confusing, like I said I'm not great at that. But hope the reasoning makes sense. If not let me know and I can try to explain a better way!