What would be the Formula for Dates to How many Days calculation?
What is the formula to tally these columns to automatically calculate how many days the each action takes to happen?
Submitted Date to First Worked on would be for Days to First Action
First Worked on date to Completed Date would be for Days to Complete
Submitted Date to Completed Date would be for Days Since Submitted
Answers

Calculations on dates are similar to calculations on numbers.
Days to First Action
=[Submitted Date][First Worked On]
Days to Complete
=[Complete Date][First Worked On]
However  is it possible to complete something without working on it? This formula will throw an inaccurate result since there is no First Worked On date populated. If this is something you need to test for before measuring the date range, you may want to consider using an IF statement to test for the blank date before attempting the calculation.
Days Since Submitted
=[Completed Date][Submitted Date]
However  on Days Since Submitted, if the product isn't complete, don't you still want to measure it to determine if something is lagging excessively in the work queue?
Let me know how that works for you.

I think so, I will try it out.
Thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!