Formula to calculate the next Friday after today
I have the formula below in Excel that calculates the next friday from today's date; so that any time the sheet is opened before a friday it will automatically insert the date for the coming friday, and when that date has passed and the sheet is re opened it will automatically insert the next fridays date in the week ending box.
Any suggestions how I can replicate this in Smartsheet?
Help Article Resources
Check out the Formula Handbook template!