Hi
I've been trying to use some new functions.
To find the date of the max value between two dates I built the followingwhich looks like overkill. Are there any other ways you can think of ?Formula:=FILTER(A1:A8,B1:B8=MAX(FILTER(B1:B8,(A1:A8>A2)*(B1:B8<A7),"")),"")
Thanks a lot
Bookmarks