From what I read in the newspapers, that isn't always a good thing <vvbg.

Bob Phillips wrote:

I agree, just on a crusade to get Americans to think worldwide <bg

Bob

"Biff" wrote in message
...
That's a good point, Bob.

I myself would not use that expression in a formula. I just don't like the
way it looks! I would use a cell to hold the date or use the Date function
in the formula.

I was just showing the OP how it could be done using the date string.

Biff

"Bob Phillips" wrote in message
...
Mr Biff,

Love to see you coercing a date with the unary operator, but could I
suggest
that you use the form

=SUMPRODUCT(((register01532!$b$7:$b$401=--"2006-01-01")

it removes all ambiguites with dates re mm/dd or dd/mm formats.


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Biff" wrote in message
...
Hi!

Question is: Why did I have to use the Date function in one formula
and
not
the other?

You didn't have to use the Date function. In the one formula you're
referencing a cell that holds the date.

In the below formula:

=sumproduct(((register01532!$b$7:$b$401=1/1/06)...

You have what *YOU* think is a date but Excel sees 1 divided by 1
divided
by
6.

Try it this way:

=sumproduct(((register01532!$b$7:$b$401=--"1/1/2006")

Biff

"Walter Mayes" wrote in message
...
In one of my spreadsheets I have a sumproduct formula that looks
down
a
column of dates and returns 7 day totals for certain items. Works
great.
The formula is, in part:
=sumproduct(((meter readings!a$4:$a$1064p$4).........

Column A contains =b4. Both columns, A and B, are formatted as dates:
I.E.
04/03/06 P4 is also formatted as a date I.E. 3-Apr-06

In another spreadsheet I was setting up a formula to get quarterly
totals. Same basic idea as the above formula. My formula is/was, in
part:

=sumproduct(((register01532!$b$7:$b$401=1/1/06)...

Column B formatted as dates. This would not work. Returned nothing
but
0's.
By modifying the formula to .....=date(2006,1,1)).... it worked.

Question is: Why did I have to use the Date function in one
formula
and
not the other?

Walter Mayes










--

Dave Peterson