# Calculating completion date from multiple turn around time and date assigned

✭✭
edited 07/28/22

Hi All,

I have created a workload management sheet. Within the sheet 1 column is for Turn Around Times (there are multiple) and 1 column is for Date Assigned. I need to calculate the Completion Date from the Turn Around Time and Date Assigned: Date Assigned + Turn around Time = X.

What is the best formula to use?

Thank you,

Lyn

• ✭✭✭✭✭

Hey Lyn,

I was looking at doing something similar a while back and this page helped me.

Hope it helps!

How to Add Days to a Date in Smartsheet (alphr.com)

• ✭✭

Hi Dakota,

This issue is the turnaround time is multiple values, it could be any number between 1 and 15. The calculations should be 'Date assigned + TAT = Completion date'. The sum formula doesn't work correctly, should I use a date formula?

Thank you,

Lyn

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!