Add date to formula
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
Best Answer
-
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,
Answers
-
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,
-
Thank you that worked!
Help Article Resources
Categories
Check out the Formula Handbook template!