Count projects for the month

Options

I'm trying to calculate total "In Progress" projects for the month, I used the below formula to calculate,

=COUNTIFS([Actual End Date]:[Actual End Date], AND(IFERROR(MONTH(@cell), 0) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1)), IFERROR(YEAR(@cell), 0) = YEAR(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1), [Project Status]:[Project Status], OR(@cell = "In progress")))

but I get #invalid data type error,


Tags:

Best Answers

Answers