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
Bookmarks