Need help with a date formula to always return a Friday date.

Options

I see there is a standard formula and you just need to change the last number depending on the day of the week.

Date@row - WEEKDAY(Date@row) + 2

The "+ 2" can be modified to pick a different day of the week. 1 = Sunday, 3 = Tuesday, etc.


Here is the formula on my sheet but is shows #unparseable.

=Customer Date Needed@row - WEEKDAY(Customer Dated Needed@row) + 6


Thanks.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!