rhettblaine
New Member
- Joined
- Oct 3, 2013
- Messages
- 29
- Office Version
- 365
- Platform
- Windows
Excel Formula:
COUNTIFS(t_data[Created],">="&Dashboard!$C$4,t_data[Created],"<="&EOMONTH(Dashboard!$C$4,0),t_data[Loan Type],"<>VA",t_data[Appraisal Reviewer Response],F7)
I'm using the formula above to count the number of accounts during the first and last day of the month the user selects. My data shows that I should have 12 accounts but the formula is only showing 11. I've noticed that the missing account is one that was created on the last day of the month (in this case, 11/30/22, if that matters).
I can correct this by adding +1 at the end of
Excel Formula:
"<="&EOMONTH(Dashboard!$C$4,0)
This isn't an isolated issue either. I have seen this in the past where using CountIfs to count between dates will skip the last day of the range.
Thanks!