Days Elapsed Based on Cell Value

[ChrisM7872]

Team,

First off, thank you for helping me with what has been racking my brain for a few days. I've read multiple sites on how to do this, but nothing has been helpful so I am turning to the experts.

What I need is a formula that lives in column C that looks at column D and if the value in that cell is "completed" then the formula returns the days elapsed between "Date Received" and "Date Completed". If the value is "in progress", then the formula returns the days elapsed from "Date Received" to the current date.

Thanks in advance.

 

[awoohaw]

=IF(D2="completed",B2-B1,Today()-B1)

 

[awoohaw]

=IF(D2="completed",B2-B1,Today()-B1)

althought, I recommend not using Today() function as it is volatile. I would use a helper cell to input it and reference that in the formulas.
Volatile functions calculate every time a calculation takes place, and if you have lots of volatile functions in the workbook you will slow it down substantially.
If you don't have many, then it isn't an issue.

 

[ChrisM7872]

Thank you.