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

Jose G. · 07/20/23

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.

Carson Penticuff · 07/20/23

If your column name contains spaces, you will need to enclose it in square brackets.

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

Paul Newcome · 07/20/23

Column names containing a space, number, and/or special character need to be wrapped in [square brackets] when referenced in a formula.

MichaelTCA · 07/20/23

What are the column properties for both Date and Customer Date Needed?

Carson Penticuff · 07/20/23

If your column name contains spaces, you will need to enclose it in square brackets.

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

Paul Newcome · 07/20/23

Column names containing a space, number, and/or special character need to be wrapped in [square brackets] when referenced in a formula.

Jose G. · 07/20/23

Both columns are date properties.

Jose G. · 07/20/23

Awesome. Thanks for the help.

Paul Newcome · 07/20/23

Happy to help. 👍️

MichaelTCA · 07/20/23

@Jose G. If the brackets fixed your issue, than great!

The NETDAYS() function works as well. Both columns would have to be dates though.

Best Answers