I can get the formula to work if I manually type in the date. However, with data validation, I have a dropdown list of the first day of the month. So, since it’s June, it says 06/01/24, and the cell next to it finds the last day of the month. Instead of manually typing the dates in the formula, I want to be able to select the date in the cell instead.

=COUNTIFS(T_LEAVE[START DATE],”>=6/1/24″,T_LEAVE[START DATE],”<=6/30/24″)

​I can get the formula to work if I manually type in the date. However, with data validation, I have a dropdown list of the first day of the month. So, since it’s June, it says 06/01/24, and the cell next to it finds the last day of the month. Instead of manually typing the dates in the formula, I want to be able to select the date in the cell instead. =COUNTIFS(T_LEAVE[START DATE],”>=6/1/24″,T_LEAVE[START DATE],”<=6/30/24″)  Read More

​