Forum Discussion
Return date verification
Hi! I am compiling an equipment list for our communications department comprising of communications equipment such as cameras, microphones etc... that they loan out to other departments. In the list,...
Hi Paul_Noble
I would suggest doing the flag calculation in a helper column like E and possibly having C turn into 'Bad' colors when not returned in time.
=AND(D3=0,TODAY()>C3,C3>0)
Then you could quite easy, with Excel 365, add H2 to result in rows over due.
=FILTER(A:C,E:E=TRUE)
Thank-you very much bosinander (and thank-you for the Swedish version of the code). Let me take a look and see if I can work in your solution and I hope it is ok if I revet to you if I have follow-up questions?
- You're welcome, also to come back with follow up questions.
And yes, by attaching an example file Excel will automatically convert to your local setup when opened. The screen shot though is as you noted with swedish settings 🙂