CountIFs EOM Formula

@Diana · 04/17/19

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.

Screen Shot 2019-04-17 at 4.17.24 PM.png

Paul Newcome · 04/18/19

=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)

CountIFs EOM Formula

Comments

Help Article Resources

Categories