CountIFs EOM Formula

@Diana@Diana
edited 12/09/19 in Formulas and Functions
04/17/19 Edited 12/09/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

Comments

  • Paul NewcomePaul 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)

    thinkspi.com

Sign In or Register to comment.