How to update a formula to automatically populate for the prior Monday to a cell date


Hi! I have the following formula from the discussion board (shoutout to Craig) for automatically populating the Monday prior to a certain date:

=IF(ISDATE(Date@row), IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - WEEKDAY(Date@row) + 2))

What do I need to change on this to have it calculate the FRIDAY prior?

I'm sure it's in the numbers, I just don't quite get it :)

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!