Days combined with Status formula

Heather Druckenmiller

I am trying to calculate the number of days between 2 dates, my calcuation is working but I now need to update it to have it only calculate if the status is "Wrong Account" and I keep getting an error.

=SUM(Date1 - [Invoice Date]1)

Andrée Starå

Hi Heather,

Try something like this.

=IF(Status@row = "Wrong Account"; SUM(Date@row - [Invoice Date]@row))

The same version but with the below changes for your and others convenience.

=IF(Status@row = "Wrong Account", SUM(Date@row - [Invoice Date]@row))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Raposo

Hi Heather,

I believe this formula should work for what you're looking for:

=IF(Status@row = "Wrong Account", Date1 - [Invoice Date]@row)

Hope this helps! Let me know if you have any questions.

Best,

Mike

Andrée Starå

Hi Heather,

Try something like this.

=IF(Status@row = "Wrong Account"; SUM(Date@row - [Invoice Date]@row))

The same version but with the below changes for your and others convenience.

=IF(Status@row = "Wrong Account", SUM(Date@row - [Invoice Date]@row))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Heather Druckenmiller

Worked perfect, Thanks!

Andrée Starå

@Heather Druckenmiller

Excellent!

Happy to help!

I noticed I made a mistake so I've fixed it.