I use the following on one of my sheets in a workbook, and would like
to use it to analyze a different column in 8 of the other 10
worksheets. How can I modify this to do that? The column I will be
looking for data in is Column P and I am looking between a range of
dates, just like in the following example:

="Installed Revenue " & SUMPRODUCT(($L$1:$L$65086),($W$1:$W
$65086=DATE(2012,4,22))*($W$1:$W$65086<=DATE(2012 ,5,21)))

In the above example, it is using a value from a completely different
column to get the sum of. In this case, I simply want to count, how
many rows have a date in Column P that fits between the dates in the
formula, so the result would be similar to this:

Orders Placed This Month (18)

FYI - our fiscal month is from the 22nd to the 21st of the following
month.

Thanks in advance for your help!

magmike