Excel Shortcut When Using Dates as Formula Criteria
Working with Dates in Excel can be frustrating because a date criteria in one formula doesn’t always work in another. Using the data below let’s say we want to summarise units sold by Product for January. Note: the data above is formatted as a Table which means we can use Structured References in our formulas …