Search for pdf files by date or title

See attached spreadsheet
the only thing you need to update is

 Const strFolder As String = "C:\Downloads\" 'Directory

change this to your directory

press the grey button and it should work

i added the hyperlink feature into this one as well

ActiveSheet.Hyperlinks.Add Anchor:=Cells(i, 5), Address:=strFolder & strFileName, TextToDisplay:=strFileName