Formula for counting rows that are past Planned Finish date

Colleen Jones

I am trying to create a formula that will count the number of row items in my Planned Finish column that are past the date in the cell. I need a summary item so that I can use it on a dashboard to show how many projects are overdue or should be closed.

I have been trying to use a COUNTIF formulas that I saw other people using, but whatever way I try to set it up, I can't get it to work and get an UNPARSEABLE error.

Any help would be appreciated. Thanks!

=COUNTIF(Planned Finish:Planned Finish, <TODAY)

Paul McGuinness

HI @Colleen Jones

You did have it just missed two pieces out.

=COUNTIF(Planned Finish:Planned Finish, <TODAY)

Just needed the brackets around the column name and after the TODAY function to close it out.

=COUNTIF([Planned Finish]:[Planned Finish], <TODAY())

Hope that helps

Thanks

Paul

Paul McGuinness

HI @Colleen Jones

You did have it just missed two pieces out.

=COUNTIF(Planned Finish:Planned Finish, <TODAY)

Just needed the brackets around the column name and after the TODAY function to close it out.

=COUNTIF([Planned Finish]:[Planned Finish], <TODAY())

Hope that helps

Thanks

Paul

Colleen Jones

YES! That fixed it. I had been playing around with those elements but didn't have them at the same time! Thank you, Paul!