Date Formula Assistance

Good day,


I need assistance in setting up a formula for tracking next service dates on equipment. I have two sheets - Sheet 1 is a schedule of Workdays and Sheet 2 is where the various equipment are listed with previous service dates etc.

Sheet 1:

Sheet 2:

C3: Workdays: C1/C2

Question 1 C4: C3 + C7 (this must be based on Workdays from Sheet 1)

Question 2 C9: (C8 - C5) / C2 + C7 (this must be based on Workdays from Sheet 1)


Thanks


CJ

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!