i think i'll just add a column and do the subtraction in the dates workbook, and
then reference that cell. seems much easier.


--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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