What I am trying to do is call back all values where the date is between 2 user inputted dates irrespective of the year. This is in order to show anniversary dates, so the year still needs to be returned, but not included in the criteria.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Range by Date (Not Including Year)
- Thread starter Noz2k
- Start date
Must have inputted it wrong as I've just tried it on a different column and it all works great.
Formula is
Thank you very much
Formula is
Code:
=IFERROR(IF($A3<>"",INDEX(Sheet2!$A$3:$A$20000,MATCH(User_Sheet!$B$1,IF((Sheet2!$A$3:$A$20000>User_Sheet!$A3)*(TEXT(Sheet2!$K$3:$K$20000,"dd/mm")+0>=TEXT(User_Sheet!$D$1,"dd/mm")+0)*(TEXT(Sheet2!$K$3:$K$20000,"dd/mm")+0 <TEXT(User_Sheet!$E$1,"dd/mm")+0),Sheet2!$E$3:$E$20000),0)),""),"")Thank you very much
Upvote
0
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Similar threads
- Question
