Is there a workday.intl equivalent in SmartSheet?

I am looking to pull in a google sheet used to manage project schedule that uses a 6 day work week to calculate schedules.

For example one cells formula is:

=IFERROR(if(E69="Mail Date", F69,if(G69="First", workday.intl(AN69,-4,11,Holidays_USPS), if(G69="Standard",workday.intl(AN69,-6,11,Holidays_USPS),"NA"))),"NA")

Is there a way to do similar calculation in SmartSheet?

I haven't found a way to define weekends like in the workday.intl.

Let me know.

Dave

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!