# Combining Two Formulas in One Cell (NETDAYS and Addition)

Options

Hi everyone,

I am looking to combine two formulas in one cell (one to calculate number of days; one to calculate completion date, using calculated days). The information below was provided to me by my supervisor to use, but I have been struggling to come up with a solution. Here is the information:

Formula: First Product Date (09/01/20) - 30 calendar days (manufacturing, sub-assembly, etc.) - Lead Time (09/01/21)

My initial approach:

NETDAYS([First Product]1, [Lead Time]1) - 30 = 336 days

[First Product]1 + 336 = 08/03/21

The first formula calculates the total days of development and production, then that calculated amount is added to the first product date to roughly guess on what specific date should I expect the project to be completed. Dates will change, but this is just an example.

Any and all help is greatly appreciated!

Tags:

• Options

Funny enough, I had tried that shortly after posting this question. It had worked, but no matter, thank you for answering my question.

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!