Countif function help for multiple date columns

Copper Contributor

Hi there, I'm trying to use countif to determine if an employee was active during a specific stat month. For the stat month, we use the first of each month (ie. 1/1/24, 2/1/24, etc.). So I need a column that countifs "Stat month" is on or after "Start Date" and before or blank for "Termination Date" 

 

My attempts have not been working out due to the requirement for "" on the criteria when using COUNTIF or COUNTIFS. Is there another way to accomplish what I'm looking for here? Thanks in advance for any advice!

1 Reply

@megansummer 

 

=SUMPRODUCT((Start_Date<=Stat_Month)*(MIN(DATE(9999, 12, 31), Termination_Date)>Stat_Month))