Try something like:

=TODAY()+6-WEEKDAY(TODAY())+(6<WEEKDAY(TODAY()))*7

Also, you can look up the WEEKDAY() & TODAY() functions in Excel's help.

Hope that helps,

TK

"Whats a Display Name?" wrote:

I need a script to put into an excell document that will automatically put
the current weeks friday's date on it.

If that makes any sense.

I.E.
Every week I need to fill out this spreadsheet.
Spreadsheet has a "Week End Date:" cell.
That is every friday

Please help. Thank you!