Note: it’s important that CF formulas be entered relative to the “active cell” in the selection, which is assumed to be B5 in this case. This formula refers to two named ranges: start (C2) and end (E2). References to the start and end dates (C2 and E2) are absolute and will not change. References to the date in column C are “mixed” — the column is locked, but the row number is free to change.
Without named ranges
This formula refers to two named ranges: start (C2) and end (E2). Without using named ranges, the formula would look like this:
Embedding dates
This formula exposes the start and end input values directly on the worksheet, so that they can be easily changed. If you want to instead embed (hard-code) the dates directly into the formula, the formula would look like this: The DATE function ensures that the date is properly recognized. It creates a proper Excel date with given year, month, and day values.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
