Date Formula to always return with next Friday Date?


Hi - Any idea if you are able to add in formulas in the date field to always have the result for the next Friday? For example, if I have a date of Thursday, 3/21; I would like the formula to reflect the next Friday date, so the cell would reflect 3/29. The dates would change but it would have a formuIa in there that would calculate the next Friday's date. Is that a possibility? I know you can do it in Excel, but can I do that in SS? Thank you in advance for your help!!

Best Answer