Date help

[JennieJ]

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 are:
='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!

 

[Guest]

Count the other trucks using the COUNTIF function.

=COUNTIF(A:A,"Our Trucks"), where column A contains the list of all trucks
and "Our trucks" is whatever value you are looking for.

The first question is a little harder to answer because I don't understand
why you need to use find and replace.

 

[JennieJ]

I'm using find/replace because I don't know how to make it automatically
go to those dates, and it's easier than changing every single equation
one at a time -- that's what I'm trying to get around.

Thanks for the help on the trucks -- I'll give that a try.