Date Formula
Options
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

something like =if(Weekday(Date15)=7,Date16,Date15) might work.
Answers

something like =if(Weekday(Date15)=7,Date16,Date15) might work.

Thanks Nik. I think I will be able to make this work.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!