Return a Future date based on criteria Weekdays only


I have this formula:

=IF([Billing Arrangement]@row = "Prepayment", [Invoice Date]@row + 3, IF([Billing Arrangement]@row = "Direct Bill", [Invoice Date]@row + 7, 0))

Can anyone give advice to correctly write this to show WEEKDAY? [Invoice Date] column would be the date column I would point to.

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!