Date help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JennieJ - 19 Jun 2006 21:13 GMT

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!

Signature

JennieJ

Reply to this Message

MarkN - 20 Jun 2006 00:57 GMT

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.

Signature

Hope this half helps!,
MarkN

> I have a spreadsheet that links to 3 worksheets in the current,
> immediately previous, and immediately succeeding day. Two of the
[quoted text clipped - 13 lines]
>
> Thanks!

Reply to this Message

JennieJ - 20 Jun 2006 13:39 GMT

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.

Signature

JennieJ

Reply to this Message