I have a spreadsheet that links to 3 worksheets in the current,
immediately previous, and immediately succeeding day. Two of the
formulas I currently have a
='P:\Volume Logs\month 2006\[prevdate.xls]Production Summary'!$E$20
='P:\Volume Logs\month 2006\[nextdate.xls]Production Summary'!E33

Is there a way to make the spreadsheet look to the previous or next
workday automatically without doing a find/replace for the
month/prevdate or month/nextdate?

I also have another section where I need to count the number of trucks
based on whether they are ours or another carrier. Right now I'm doing
that manually off yet another spreadsheet (I didn't set this up!) -- I
know of the "count" function but don't know how to tell it WHAT to
count.

Thanks!


--
JennieJ
------------------------------------------------------------------------
JennieJ's Profile: http://www.excelforum.com/member.php...o&userid=35576
View this thread: http://www.excelforum.com/showthread...hreadid=553396