Looking for a Next friday Date Script
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!
|