Count in date range

lesmickin
lesmickin ✭✭
edited 12/09/19 in Smartsheet Basics

I have a field - Let's say Closed Date

I am wanting a count of only those with close dates between 9/1/19 and 9/30/19.  I keep trying different formulas but i keep getting the unparseable error :(

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try something like this...

     

    =COUNTIFS([Closed Date]:[Closed Date], AND(IFERROR(MONTH(@cell), 0) = 9, IFERROR(YEAR(@cell), 0) = 2019))

     

    This will give you the count of all dates that fall within the month of September in 2019.

    .

    If you need to be able to specify the dates, you can try something like this...

     

    =COUNTIFS([Closed Date]:[Closed Date], AND(@cell >= DATE(2019, 09, 01), @cell <= DATE(2019, 09, 30)))

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com