Help with Date formula

Jon Barto
✭✭✭✭✭
Is there a way to take a date in one column 1-21-25 and return the friday date in that week in another column? 1-24-25 would be the return date.
Thanks
Answers
-
Hello @Jon Barto
I think you benefit a lot from this Community Thread, it addresses your inquiry:
Date Formula to always return with next Friday Date?
Hope this helps!
Marce
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!