Still not sure that I understand the issue as I didn't find any instances where N/A was in column D and a date was listed in column E or visa versa.
I made the following changes:
1. On the first sheet in column F found and replaced #N/A with N/A
2. Replace text in dashboard row 22 with first dates of each month custom formatted mmm yyy
3. Rows 23:26 are populated using: =COUNTIFS('Subject to the Rehire Procedure'!$E:$E,">="&EOMONTH(B$22,0)+1,'Subject to the Rehire Procedure'!$D:$D,"<="&EOMONTH(B$22,0),'Subject to the Rehire Procedure'!$F:$F,$A23)
4. Row 27 is populated using: =COUNTIFS('Subject to the Rehire Procedure'!$E:$E,">="&EOMONTH(B$22,0)+1,'Subject to the Rehire Procedure'!$D:$D,"<="&EOMONTH(B$22,0))
If this doesn't do what you want I suggest you give us a specific cell on the dashboard sheet that is misreporting and let us know what the expected value should be and why.
Let us know if you have any questions.
Bookmarks