Microsoft, Excel, 2003, VBA - Creating a workday function
Posted on 2008-06-16
Hi, i need to create a function that I can use in a vb macro i am creating or in any future macros.
the format needs to be WORKINGDAYS(Startdate,EndDate) and it needs to take into consideration bank holidays.
this seems relatively straight forward but i dont know the vb commands to recognise which number is a saturday or sunday, also the formats of my dates just seem to return 0 all the time and I dont know how to make it recognise the dates properly.
example: 16/06/2008 - 12/06/2008 = 0 when i would expect this to equal 4
Any help greatly appreciated.