Thread: [Solved] Index Match Function with a Date
View Single Post
 
Old 01-09-2023, 04:59 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 867
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
From:
Quote:
Originally Posted by Priyantha Gamini View Post
I try to get only Year & Month from B3 Cell to match with column "A" in the "Data" Sheet.
I took it that datewise, the OP wanted only a month and year match, so that dates didn't need to be the first of the month everywhere.
Reply With Quote