LinkBack URL
About LinkBacks
You can use a array formula like this:
=MAX(IF(A2:A100>=TODAY(),IF(A2:A100<=TODAY()+45,B2:B100)))
confirm with CTRL+SHIFT+ENTER
adjust ranges as required
You can use a array formula like this:
=MAX(IF(A2:A100>=TODAY(),IF(A2:A100<=TODAY()+45,B2:B100)))
confirm with CTRL+SHIFT+ENTER
adjust ranges as required
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks