How do I change the date range in this formula to reference the date (text type) fields highlighted?

BettyJo

I need to change the date range in this formula a lot…how do I reference cells to create the date range?

KPH

If the cell that contains the date is a date formatted column you can simply replace

>=DATE(2025,3,1)

with the cell reference> If this date was in row 12 in the Submission column date, that would be:

>=[Submission Date]12

If the cell that contains the date is a text column, you need to use the date function and add each part. If the three parts of the date were in 3 different columns in row 1 of a sheet, you could use:

>=DATE([column with year in]1, [column with month in]1, [column with day in]1)

If the date is in a text column in one cell (not split into year, month, and day) then you need a more complicated formula to separate the 3 parts before bringing them back together again with the DATE function.

If you share examples of how your date is entered, we can help extract the parts from the text string.

KPH

If the cell that contains the date is a date formatted column you can simply replace

>=DATE(2025,3,1)

with the cell reference> If this date was in row 12 in the Submission column date, that would be:

>=[Submission Date]12

If the cell that contains the date is a text column, you need to use the date function and add each part. If the three parts of the date were in 3 different columns in row 1 of a sheet, you could use:

>=DATE([column with year in]1, [column with month in]1, [column with day in]1)

If the date is in a text column in one cell (not split into year, month, and day) then you need a more complicated formula to separate the 3 parts before bringing them back together again with the DATE function.

If you share examples of how your date is entered, we can help extract the parts from the text string.