Hi Jonathan,
To count the number of dates in a column that are 30 days older than today, you can use the
COUNTIFS function in Excel. Here's how you can do it:
- Select a cell where you want to display the result.
- Type the following formula:
Code:
=COUNTIFS(L7:L155,"<"&TODAY()-30)
- Press Enter to get the result.
This formula uses the
COUNTIFS function to count the number of cells in the range
L7:L155 that meet the following criteria:
- The cell value is less than today's date minus 30 days (i.e., the date is 30 days older than today).
The "<" operator is used to compare the cell value with the date calculated by the
TODAY() function minus 30 days. The "&" operator is used to concatenate the "<" operator with the result of the
TODAY() function minus 30 days.