Search results

There is a weekday function weekday(date, firstDayofWeek) If firstDayofWeek is set to vbSunday, then the function returns 1 for sunday, 2 for monday, etc So you could check what day of the week your given date was, then subtract or add the appropriate number to get your monday and sunday

I have an Excel worksheet, with a User Defined Function- that talks to an Access database and returns a single value according to various parameters, its to give my users a very simple way to talk to the database. Its slooooow. The worksheet has nearly 100 of these in, and it takes over 5...