Counting formula just based on Status

julieg

julieg

Hello, I"m trying to come up with a formula that will start counting when status changes to "Overdue" and stop counting when status changes to "Complete" (or when date completed is not blank). Is this possible without referencing a date column?

Thanks for your help,

Julie

Toufong Vang

You'll need to reference a date if you plan to count the number of days the item has been "Overdue".

NETDAYS( due_date, TODAY() ) will return the number of days that has elapsed since the item's due date.

A date is not needed if you simply want to count the number of items that are "Overdue".

COUNTIF( Status:Status, Status@row="Overdue") will return the number of items that have "Overdue" in the Status column.

julieg

Toufong,

Thank you so much for responding so quickly. Can you tell me is it possible to modify the formula

NETDAYS(due_date, TODAY() )

to also stop counting when completion date is not blank?

thanks for your help.

julieg

I'm currently trying this formula, but am receiving INVALID DATA TYPE

=NETDAYS([Due Date]:[Due Date], TODAY())

The Due Date Column is a "Date" column. Anything obvious I'm missing? Thank you.