When I enter Max's formula it works.

Possible problems a
-- You didn't enter the formula exactly as shown (if you are getting FALSE
as a result, this is most likely your problem)
-- Your dates are text, rather than true Excel dates (what happens when you
format the cell to General?)

Regards,
Fred

"Don" wrote in message
...
Hi Max. I tried this and it did not work. All it displayed was FALSE. I
tried to enter 3-22-2010 in B5, B8, and B4. All it said was FALSE. Any
other suggestions?


"Max" wrote:

Think you could fashion it like this, using sumproduct
In O4: =IF(SUMPRODUCT(--(DAY(B3:B30)21))0,N4,0)
Success? hit YES below
--
Max
Singapore
---
"Don" wrote:
=IF(DAY(B3:B30)21,N4,0) I'm trying to use this formula to check
in
column B if a date of the 22nd of the month was entered (manually). If
it
was, then the cell (O4 in this instance) would be equal to the contents
of
cell N4, which is a numeric value. Otherwise, cell O4 would be equal
to zero
(0). The problem I'm having is that the range (B3:B30) is not being
checked
- it doesn't work. Furthermore, B4 is the only cell that allows this
formula
to work. Can't figure that one out. Do I need to rewrite the formula?
Any
help would be appreciated. Thanks!