I have 2 dates startdate and enddate. I used @Explode to get the datelist in between the start and end dates. My problem is how can I exclude the weekend of that datelist.
startdate = Jan 4, 2008
enddate = Jan 8 2008
datelist = Jan 4, Jan 5, Jan 6, Jan 7, Jan 8
however Jan 5 and Jan 6 are weekends
how can I remove them from the list (using @Function) so my datelist will only contain Jan 4, Jan 7 and Jan 8?