Ctrl + F to search for date in excel

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,671
Office Version
  1. 365
Platform
  1. Windows
Hi
I am trying to search for a date in my excel sheet. So I click on Ctrl + F and typed the date. No matter how I type the date, it wont be able to find it. How to search for a date? should I use the same exact format when I search or any format, DD-MM-YY or MM-DD-YY or what? I tried all, nothing works. Thank you so much.

Book1
AB
113-Mar-1903-Apr-19
203-Apr-1925-Apr-19
323-Apr-1925-Apr-19
424-Apr-1925-Apr-19
530-Apr-1901-May-19
602-May-1906-May-19
703-May-1907-May-19
806-May-1920-May-19
Sheet2


PS: I just tried this.. I cleared the format of these dates (CLear-->format) then I went to Home-->Number-->Short date. The I copied one date and went to CTRL+F and paste that date and excel found it. So is that the solution? Do I have to change the format? Thank you
 
Last edited:

EXCEL MAX

Active Member
Joined
Nov 11, 2020
Messages
382
Office Version
  1. 2007
Platform
  1. Windows
If your date is formatted as text you can search by any part of date.
If your date is formatted as date, it's number and you need to search for any part of date separated by dot.
You can't search for a date the way you trying, because search parameter it's not part of any one of date.
To check cell date format you can use "ISNUMBER" function.
If you have mixed dates in the range, search will not be precise untill all dates have same format.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,127,315
Messages
5,623,950
Members
416,001
Latest member
teabag

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top