Help with date search

  • Thread starter Thread starter Gorillaman13
  • Start date Start date
G

Gorillaman13

I'm looking to create a search function for an Excel workbook that will
find all dates prior to the date entered. As far as I can tell, Excel
can only find ones that match. I don't know VB, so could use help.

Thanks
 
Why not use one of the filter functions. (Data=>Filter=>Autofilter, select
custom in the dropdown for that column and then use before and enter your
date. you can turn on the macro recorder if you need code to perform the
same way.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date question 4
Date subtraction 1
VBA to Assign Outlook Task 2
Dates prior to 1900 are text 3
Error with Date Picker 3
Excel is changing date format incorrectly 7
Find date 4
Excel Help! Duplicating info from other tabs to a Master tab 0

Back
Top