excel date search

  1. E

    Convoluted Date Matching between 2 Worksheets

    Hello, I have two worksheets. 1) Row Names = Year Coumn Names = Month Each cell has an unemployment rate. There is also a column for state abbreviation. So it is unemployment rate, by month, by year, by state. This data was originally comprised of separate tables for each state, again with...
  2. 1

    Search Date for Year where Date is Stored in Varying Text Format

    Here is a formula which I am using to identify if a date is within a financial year from a date stored as text with varying formats and lengths. <TABLE style="WIDTH: 855pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1139 border=0 x:str><COLGROUP><COL style="WIDTH: 23pt...

Some videos you may like

This Week's Hot Topics