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!