Thread: [Solved] Index Match Function with a Date
View Single Post
 
Old 01-07-2023, 06:49 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 872
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
maybe:
Code:
=INDEX(Data!$D$2:$D$13,MATCH(1,(YEAR(Data!$A$2:$A$13)=YEAR($B$3))*(MONTH(Data!$A$2:$A$13)=MONTH($B$3))*(Data!$B$2:$B$13=$B$1),0))
?
Reply With Quote