Ctrl + F to search for date in excel

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,672
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:

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

EXCEL MAX

Active Member
Joined
Nov 11, 2020
Messages
384
Office Version
  1. 2007
Platform
  1. Windows
Hello Lezawang,
type in the search box this "30.4.2019"
 

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,701
Office Version
  1. 2016
Platform
  1. Windows
I have just checked and in Ctrl + F it should find your dates. Could you upload a version of the data exactly as you have it without the adjusted format so we can take a look and see what the issue is.
 

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,672
Office Version
  1. 365
Platform
  1. Windows
Update.. when I click on a cell and go to formula bar, I see this date 06/05/2019
When I search for this date exactly this format then I will find it.. but when I use 06-may-19, it wont find it, or when I use 06-05-19, it wont find it.
Yes I am going to upload the file. Thank you so much
 

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,672
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

I just uploaded the file here:


Thank you very much
 

EXCEL MAX

Active Member
Joined
Nov 11, 2020
Messages
384
Office Version
  1. 2007
Platform
  1. Windows
Is your dates typed latin or cyrillic.
Try to search with fonts that document is typed.
 

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,672
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Hi the font is Calibri. Not sure what do you mean but latin or cyillic.
I copied one cell and then Ctrl+F and paste the cell content and click on search, excel did not find it! thank you.
 

EXCEL MAX

Active Member
Joined
Nov 11, 2020
Messages
384
Office Version
  1. 2007
Platform
  1. Windows
When I open on google drive I see dates with cyillic letters ("13-мар-19").
Maybe is up to my location. Forget.
When I open downloaded file it is normal, and search works with this type of search "30.4.2019".
 

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,701
Office Version
  1. 2016
Platform
  1. Windows
I think it doesn't find because of the Font. If you try this it will work.

Choose empty cell and then use Ctrl + F then choose the format Under Font change the font from Calibri (Body) to Calibri and font as regular and size as 12. Give that ago and it should work.

Dates.png
 

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,672
Office Version
  1. 365
Platform
  1. Windows
I did try that but it did not find the date.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,589
Messages
5,625,671
Members
416,125
Latest member
NeedExcelHelp2021

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