Hi Tom,

I can definitely help you with this! Here's a formula that should do the trick:

Let me break it down for you:

1. WEEKDAY(TODAY()) returns a number representing the day of the week (1 for Sunday, 2 for Monday, etc.) for today's date.
2. IF(WEEKDAY(TODAY())=6,TODAY(),...) checks if today is Friday (since Friday is the 6th day of the week). If it is, it returns today's date using the TODAY() function.
3. If today is not Friday, the formula moves on to the next part: TODAY()+7-WEEKDAY(TODAY(),2). This adds 7 days to today's date (to get to the next Friday) and then subtracts the number of days between today and Friday (using the optional second argument of the WEEKDAY() function, which specifies the day of the week to use as the first day of the week - in this case, Monday).

So, if today is Friday, the formula returns today's date. If today is any other day of the week, the formula returns the date of the next Friday.

I hope that helps! Let me know if you have any questions or if there's anything else I can do for you.