| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Script to insert the next Friday
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Script to insert the next Friday
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to display next Friday from B1 works except on the Friday itself. | Excel Discussion (Misc queries) | |||
| Need VBA script to auto-insert value upon row insert | Excel Worksheet Functions | |||
| Looking for a Next friday Date Script | Excel Programming | |||
| Looking for a Next friday Date Script | Excel Programming | |||
| Script to insert the next Friday | Excel Programming | |||
Linear Mode
