Filter with date range

[rme01]

I'm continuing working with the Filter function. This time, I am including the AND (*) logic to the filter. I want to filter out based on date. My initial range is a span over two years. I want to capture one month at a time. This is my formula but I'm getting a #Calc error. I was able to have it work once and then it fizzled on me.

=FILTER('Service Tech Summary'!$U$29:$U$38,('Service Tech Summary'!$C$29:$C$38=C3)*('Service Tech Summary'!$D$2>=DATE(2020,11,1))*('Service Tech Summary'!$D$3<=DATE(2020,11,30)))

[Fluff13]

#CALC! means that there is no data that matches all 3 criteria.
If you think there should be, then can you upload a sample workbook showing the problem.

[rme01]

I would be I'm under an NDA agreement and it is sensitive information.

The date range is 1/1/1990 thru today. I'm separating the information by month therefore there is information for each month. Currently, I'm changing the date range and copying and pasting values onto another worksheet. Instead of copying and pasting values, I would like to use the filter function and have it be based for each month therefore eliminating the need to change date range and providing accurate information.

[Fluff13]

Missed it originally, you are only checking D2 & D3 for the date, should it be D29:D38?
Also if you have data from 1900 to the present, why are you only filtering 10 rows?

[rme01]

D2 is the beginning (1/1/2020)
D3 is end date (1/31/2020)
U29:U38 is my data
C29:C38 is my list of people
C3 is my target person for that row.

[rme01]

My data is broken down into different categories.

[Fluff13]

D2 is the beginning (1/1/2020)
D3 is end date (1/31/2020)

that explains why you get #CALC!, those dates are out side your criteria range.

[rme01]

If I set my begin date at 1/1/2019 and the end date 12/31/2025. Apply the formula that I have above, I still get the #Calc error.

[rme01]

If I set my begin date at 1/1/2019 (D2) and the end date 12/31/2025 (D3).

[rme01]

I want to capture one month at a time within that timeframe.

[Fluff13]

As I have no idea what your data looks like (& it sounds as though it is not in a normal layout) there is nothing more I can do to help.

[rme01]

I just uploaded a small sample. I hope this clears up any confusion

[rme01]

Again, ideally, D2 would be the initial date of 1/1/1999 and D3 would be a future date.

[Fluff13]

I hope this clears up any confusion

Fraid not, as there is nothing of any use in those images.
If you don't have the date on each row of data, how do you know which date it for?
Also with data from 1900 to today, I would expect you to have 10 of thousands of rows, not just 10.

[rme01]

The data in each cell contain a Countif formula which is referenced to the dates (d2 & d3). For example,

=COUNTIFS('Data from Google Version'!D:D,$C8,'Data from Google Version'!E:E,"Maintenance",'Data from Google Version'!B:B,">="&$D$2,'Data from Google Version'!B:B,"<="&$D$3)

[Fluff13]

That does not help & makes even less sense.
Without being able to see your data & understand exactly what you are trying to do, then I cannot help as nothing you have said makes any sense to me.

[rme01]

Worksheet one...
Includes information for a large timeframe such as 1/1/1997 thru 7/31/2022.
Information includes what I have included in post 10. with the countifs formula

Worksheet two...
I want to filter designated cells from worksheet one and include specific dates on a month basis. For example, July 1 to July 31, 2021. Instead of copying/pasting cell values, I would like to have the filter formula for each month.

[JeteMc]

As Fluff13 has said it is hard to offer help without at least having an Excel file with some fictional data with which to work.
That said, looking at the formula in post #1, I feel that the culprit may be the segment: 'Service Tech Summary'!$C$29:$C$38=C3
Assuming Aaron W. is in cell B3, I imagine that the segment should read: 'Service Tech Summary'!$C$29:$C$38=$B3.
Let us know if you have any questions.