Add date to formula

Sara Moore

Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date" with dates (2/20/2021) in them. I want the total number of slides in the next 30 days. Could you please help me with this. Thanks

Kelly Moore

Try this

 =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist", [Due Date]:[Due Date], AND(TODAY() <= @cell, @cell <= TODAY(30)))

Please ensure that your Due Date column is formatted as a Date column

cheers,

Kelly Moore

Try this

 =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist", [Due Date]:[Due Date], AND(TODAY() <= @cell, @cell <= TODAY(30)))

Please ensure that your Due Date column is formatted as a Date column

cheers,

Sara Moore

Thank you that worked!