Hello I have a report that run everyday at 4:00PM to show the statistics from 4:00PM yesterday to 4:00PM today. If the holiday is falling on Wednesday, when I come to work which is Thursday, the report will show me the statistics for two days (Wedneday, and Thursday). I use wdaysClass1wdLoadFile (wdFilePath) functions and put in the Holiday, but I don't know how to write formula after that. I also used wdaysClass1wdIsWorkDay (wdDate, wdDays) functions, but there are 10 holidays in a year, I don't want to manually put in for each holiday, this is nut. Can someone shed some light on me. Thanks in advance
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Holiday formula
- Thread starter tumap
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question