Ctrl + F to search for date in excel

[lezawang]

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
	A	B
1	13-Mar-19	03-Apr-19
2	03-Apr-19	25-Apr-19
3	23-Apr-19	25-Apr-19
4	24-Apr-19	25-Apr-19
5	30-Apr-19	01-May-19
6	02-May-19	06-May-19
7	03-May-19	07-May-19
8	06-May-19	20-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

 

[EXCEL MAX]

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.