Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
?
Lv 4
? asked in Computers & InternetSoftware · 3 years ago

Could I find the same date in two excel sheet?

1 Answer

Relevance
  • garbo7441
    Lv 7
    3 years ago

    Yes, but using formulas would simply tell you if the date exists in another worksheet, or how many instances of the date occur in another sheet. They would not identify the cell address, or addresses.

    For example, if you have a date in A1 of Sheet1 and the same date in F41 of Sheet2, this formula would return '1':

    =COUNTIF(Sheet2!A1:X2000,A1)

    or 'Yes':

    =IF(COUNTIF(Sheet2!A1:X2000,A1)>0,"Date Found","")

    You could also specify the date rather than using a cell reference:

    =COUNTIF(Sheet2!A1:X2000, DATE(2018,1,1))

    In order to identify the cell locations you would have to use a VBA routine. This method could check any, or all, sheets in the workbook.

Still have questions? Get your answers by asking now.