Trying to count if data range falls between two dates.

Art A

I have a sheet with StartDate and EndDate fields. I want to count actual items opened on a separate sheet if the date falls between the start date and end date. The below formula keeps returning #UNPARSEABLE and I suspect its something minor.

=COUNTIFS({Request Tracker with Form Range 1}, "<=" & (EndDate@row),{Request Tracker with Form Range 1}, ">=" & (StartDate@row))

heyjay

=COUNTIFS(
{Request Tracker with Form Range 1}, <= (EndDate@row),
{Request Tracker with Form Range 1}, >= (StartDate@row))

and make sure that the date columns and actually formatted as DATE in their properties.

Alex_L_Oncor

=COUNTIFS({Request Tracker Form StartDate},>=[StartDate]@row,{Request Tracker Form EndDate},<=[EndDate]@row)

I think that should work or something similar. If not a way to surely accomplish this would be to add a column to your other sheet. Make that column have a text like "Between"

=IF(AND(DATE@row>=[StartDate]@row, DATE@row <= [EndDate]@row),"Between","")

On the separate Sheet your equation can now be

=COUNTIF({Between?},"Between")

Hope this helps.

heyjay

=COUNTIFS(
{Request Tracker with Form Range 1}, <= (EndDate@row),
{Request Tracker with Form Range 1}, >= (StartDate@row))

and make sure that the date columns and actually formatted as DATE in their properties.

Alex_L_Oncor

=COUNTIFS({Request Tracker Form StartDate},>=[StartDate]@row,{Request Tracker Form EndDate},<=[EndDate]@row)

I think that should work or something similar. If not a way to surely accomplish this would be to add a column to your other sheet. Make that column have a text like "Between"

=IF(AND(DATE@row>=[StartDate]@row, DATE@row <= [EndDate]@row),"Between","")

On the separate Sheet your equation can now be

=COUNTIF({Between?},"Between")

Hope this helps.

Art A

That worked, thanks! There is enough of a difference in syntax from what I'm use to I get stuck on some trivial stuff sometimes.