It's usually acceptable to bump a thread after not receiving a response for a day, I would say 12 hours at the very least.
=SUMPRODUCT(--(D5:D10<E3+14),--(E5:E10<>"VACCANT"))
OR
=COUNTIFS(D5:D10,"<"&E3+14,E5:E10,"<>VACCANT")
Not tested the last one.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
senjuti.sarkar 
Register To Reply
Bookmarks