Hello,
In my sheet, I need a cell displaying closest date to today whose priority must be high and status must be open.
There is a column named Date, Priority and Status. I want a date closest to today's date from DATE column values whose Priority must be high and status should be open.
Attached is my sheet. I tried displaying at N10.
Thanks in advance.
welcome to the forum, pri6322. it would be good if you let us know what should the answer be too. i'm guessing it's C9. so:
=SUMPRODUCT(MAX((C9:C22<=TODAY())*(G9:G22="High")*(H9:H22="Open")*C9:C22))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thats perfect. The answer is C9.
Thanks beneshiryo.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks