Or a little simpler:

=TODAY()-WEEKDAY(TODAY()+1)+7

"T Kirtley" wrote in message
...
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


"Mark Langendoerfer" wrote:

I'm looking for a simple script that will update a date to whatever the
next
Friday will be. For example if I open the document on Thursday the 12th I
would want the cell to read Friday the 13th. If I opened the sheet on
Saturday the 14th I would want the cell to read Friday the 20th.

Any examples would be appreciated!

thank you