I have a vbscript that adds 4 days to a Status date from our database. I need to exclude holidays and sundays from the dateadd function.
For example if the status date is today (7/14/2009) and add 4 days, it would be Saturday (7/18/2009).
If the status date is tomorrow (7/15/2009) and add 4 days, it would need to exclude Sunday and result = 7/20/2009
If the status date is 7/1/2009 and add 4 days, it would need to exclude Saturday ( 4th of July Holiday) and Sunday and result = 7/7/2009
Any ideas how to do this? Thanks.
nowdate = datevalue(Status_Date_INLQ("Redisclosed to Borrower"))
Result = dateadd("d",4,nowdate)