Count days overdue only

[Photochain]

Can someone help please. I’m trying to count days overdue in column e only when item is not closed out in column N.
Have managed the following formula =IF(OR(C2>TODAY(),AND(D2<>””,D2<C2),C2=“”,),””,TODAY()-C2) but that is highlighting the row that’s overdue but not counting the days. Thanks I’m advance

[TMS]

Put your formula

=IF(OR(C2>TODAY(),AND(D2<>"",D2<C2),C2=""),"", TODAY()-C2)

in cell E2 and copy down.

[Glenn Kennedy]

To avoid negative values when the due date is still in the future (e.g. row 6), use:

=IF(N2="No",MAX(0,TODAY()-C2),"")

[Photochain]

To avoid negative values when the due date is still in the future (e.g. row 6), use:

=IF(N2="No",MAX(0,TODAY()-C2),"")

Thanks that’s worked in it’s only highlighting cells e2 and e4 red but it’s still not counting the days.

[Glenn Kennedy]

It's not highlighting the cells.... You asked about COUNTING, not highlighting... and it IS counting the cells.

I have now added some conditional formatting to highlight the cells.

[Photochain]

It's not highlighting the cells.... You asked about COUNTING, not highlighting... and it IS counting the cells.

I have now added some conditional formatting to highlight the cells.

Sorry Glenn as you can gather excel is not my forte that’s amazing thanks so much I’ve been trying for a week on and off to figure it out myself🙈
Sorry I didn’t explain myself properly at the start really appreciate it. Thank you.

[Glenn Kennedy]

It happens to all of us!! You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

[TMS]

Bit bemused. Did you miss my post? You said it's not counting the days ... that's because you didn't have a formula in column E to calculate the value, only CF to highlight cells in the row.

[Photochain]

Apologies I’m working off mobile phone here (job has this website blocked)and I didn’t see your reply. I can see it now. Thanks so much for taking the time to help me too I haven’t a clue what I’m at in excel ......or forums clearly 🤣

[TMS]

You're welcome. Thanks for the rep.