Excel vba .Find() function on a list of dates which appear as #

Excel vba .Find() function on a list of dates which appear as #

I'm currently working in a spreadsheet that has a row of dates, but all of
the dates appear as a # because the column widths are too narrow. I am
trying to perform a find function but it only works if the columns are
wide enough to see the dates.
I have a work around using a loop, but there are many hundreds if not
thousands of dates to look through everytime I call the function so it's
seriously bogging me down.
Does anyone know if it is possible to use the .Find function without the
dates actually being vissible as dates? I unfortunately cannot widen the
columns enough given formating conerns and need to be able to access the
data stored in the rows underneath by date.