i have starting dates in a workbook called dates in range B1:B12 (the closed
workbook)
i am trying to subtract one from the another to come up with the number of days.
i can get it to work if dates is open.

tried this, doesn't work but don't want to spin my wheels if it's not possible.
sheet numbers are 1 to 12.

pDays = Application.Evaluate("='" & fPath & "[dates.xls]sheet1'!$b$" & sht.Index
+ 1) - _
Application.Evaluate("='" & fPath & "[dates.xls]sheet1'!$b$" &
sht.Index) - 1


is it possible?

--


Gary