| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Networkdays to open previous day's file
Hi,
I am trying to use the networkdays function to open a previous day's file. I am receiving an error that the function is not defined. Why do I need to define this Microsoft function? Any suggestions on how to open a previous day's file that is saved as FileJul3108 excluding the day before if it was a weekend day or holiday? PrevSuffix = Format((NETWORKDAYS((DateAdd("d", -1, Date)), , HolidayList)), "Mmmddyy") HolidayList = Array("Sep0108", "Nov2708", "Dec2508", "Jan0109", "Jan1909", "Feb1609", _ "Apr1009", "May2509", "Jul0309", "Sep0709", "Nov2609", "Dec2509") -- Thank you Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Who has this workbook open showing previous users | Excel Discussion (Misc queries) | |||
| Can I reverse a saved file to the previous file in Excel? | Excel Discussion (Misc queries) | |||
| why does excel always open the previous files ? | Excel Discussion (Misc queries) | |||
| How can I open previous version of saved file in Excel? | Excel Discussion (Misc queries) | |||
| excell 2003 will not open previous version | Excel Discussion (Misc queries) | |||
Threaded Mode
