CountIFs EOM Formula

@Diana ✭✭
edited 12/09/19 in Formulas and Functions

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


=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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!