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 |
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 |
All times are GMT +1. The time now is 04:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com