Date Formula

Michael Pierson
edited 10/15/21 in Formulas and Functions

I have a formula that subtracts 5 days from an entered date to give me a due date. The days I subtract do not count Sundays or Holidays. However, if the due date falls on a Saturday, I need it to subtract one more day. No due date can be on a Saturday. I am not able to create a formula to recognize Saturday and minus one day. Can you help me with a formula for this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!