CountIFs EOM Formula

@Diana

Is there and EOM formula that will use the Month Column instead of manually using the DATE (2019,1,31) format?

Excel example:

=COUNTIFS(Type of Lead,"Servicing",Date Received,">="&B5,Date Received,"<="&EOMONTH(B5,0))

Smartsheet:

=COUNTIFS({Type of Lead},"Servicing", {Date},>=DATE(Month1),{Date},<=EOM(Month1))

Any help would be much appreciated.

 

Paul Newcome

=COUNTIFS({Type of Lead},"Servicing", {Date}, MONTH(@cell) = 1)

 

Just change the 1 to a 2 for Feb., 3 for March, etc...

 

Or you could have an additional column (which can be hidden to keep the sheet looking clean) with the corresponding month numbers and reference that in your formula

 

=COUNTIFS({Type of Lead},"Servicing", {Date}, MONTH(@cell) = [Month Number]@row)