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!
Bookmarks