Working with Dates in VBA

[cstimart]

OK, I need to create a function via VBA that will do the following.

I have 2 separate workbooks. "Template" and "Data"

On workbook(Template), Cell T11 is where I would want to put the function, which would have use the value in B11 (a date) as the Monday date.

Then, I would want the function to count the number of cells in workbook(data), Tab1, column V that are within that date range....but it would NOT count those cells if the corresponding column U cell is within that same data range.

Any ideas?

 

[cstimart]

I was able to create a sub that will calculate the number, as I was unable to have a function open/access a different worksheet. Am I missing something, or is that not possible?