Run Error 5: Sorting Dates and Data

Hi,

So the initial problem I'm trying to solve is I have a spreadsheet with a column with a lists of dates and another column with a list of corresponding priority. So what I want it to do is go through the list, start a tab of how many workdays there are total in the range, also tabulate how many of each instance of priority there are and then return that information in a different spreadsheet to represent how many of these occur on a daily (averaged) basis. With the On Error Goto removed, the error occurs when I use the DateDiff function

Please Login or Register  to view this content.

Any help would be great. Thanks.

Originally Posted by acidtrik

the error occurs when I use the DateDiff function

Please Login or Register  to view this content.

The interval in the DateDiff function has to be a string, so change the above to:

Please Login or Register  to view this content.

thanks that did the trick