Main Profile

At A Glance

Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmLearn how to extract weekly records given a single date during the week's period1. Take daily transactional records and extract the records for the week with an array formula.2. See the functions, DATE, YEAR, MONTH, DAY, WEEKDAY, COUNTIF, IF, ROWS, INDEX, SMALL, ROW.
Length: 12:46

Contact

Questions about Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010

Want more info about Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question