Count + IF Statement?

Jolene Kostick

I would like to count the days from the 'Date' to the 'Date of Completion' once entered and have the counted days in the 'Turn Around Days' column when the status column is clicked 'Complete'

Something like IF Status = complete and the Date is < or = Date of Completion then Turn Around Days are 6 (in this case)

A million dollars for the correct answer as I have no hair left.

Thank you wizards!

Nic Larsen

There's the issue. It's the primary Column which can only be text/number. Create a new Date column and assign it as a date column.

Nic Larsen

Try: =IF(AND(Status@row = "Complete", Date@row <= [Date of Completion]@row), [Date of Completion]@row - Date@row)

Jolene Kostick

Hi Nic,

It says Invalid operation at the moment!

Jolene Kostick

Pictures always help me- although not in this case! I appreciate your help.

Nic Larsen

Can you confirm that both of your date columns are set to Date type columns? When I switch to a text column then I also get Invalid Operation error.

Copy of my columns plus formula:

Jolene Kostick

I can confirm this, yes. I can't change the first Date column because:

Nic Larsen

There's the issue. It's the primary Column which can only be text/number. Create a new Date column and assign it as a date column.

Jolene Kostick

Your tricks work. Thanks Nic!