HELLO

I am looking for a if formula that shows yes one of B12: AL12 equal to
todays date

On Mon, 10 Aug 2009 04:16:07 -0700 (PDT), Tia wrote:

HELLO

I am looking for a if formula that shows yes one of B12: AL12 equal to
todays date

You don't write what you want to happen if NONE of those cells are equal to
today's date. But this should get you started:


=IF(OR(B12:AL12=TODAY()),"Yes")

This formula must be **array-entered**:

----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. If you did this
correctly, Excel will place braces {...} around the formula.
--ron

On Aug 10, 3:39*pm, Ron Rosenfeld wrote:
On Mon, 10 Aug 2009 04:16:07 -0700 (PDT), Tia wrote:
HELLO

I am looking for a if formula that shows yes one of B12: AL12 equal to
todays date

You don't write what you want to happen if NONE of those cells are equal to
today's date. *But this should get you started:

=IF(OR(B12:AL12=TODAY()),"Yes")

This formula must be **array-entered**:

----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. *If you did this
correctly, Excel will place braces {...} around the formula.
--ron

Thank you very much its is woking like a sharm but whenever i am
putting it in a row that contains a #NUM! its is giving me num even if
there is todays date
ANY IDEAS ?

Try...

=IF(ISNUMBER(MATCH(TODAY(),B12:AL12,0)),"Yes","")

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article
,
Tia wrote:

On Aug 10, 3:39*pm, Ron Rosenfeld wrote:
On Mon, 10 Aug 2009 04:16:07 -0700 (PDT), Tia
wrote:
HELLO

I am looking for a if formula that shows yes one of B12: AL12 equal to
todays date

You don't write what you want to happen if NONE of those cells are equal to
today's date. *But this should get you started:

=IF(OR(B12:AL12=TODAY()),"Yes")

This formula must be **array-entered**:

----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. *If you did this
correctly, Excel will place braces {...} around the formula.
--ron

Thank you very much its is woking like a sharm but whenever i am
putting it in a row that contains a #NUM! its is giving me num even if
there is todays date
ANY IDEAS ?

Does this work for you...

=IF(COUNTIF(B12:AL12,TODAY()),"Yes","No")

--
Rick (MVP - Excel)


"Tia" wrote in message
...
On Aug 10, 3:39 pm, Ron Rosenfeld wrote:
On Mon, 10 Aug 2009 04:16:07 -0700 (PDT), Tia
wrote:
HELLO

I am looking for a if formula that shows yes one of B12: AL12 equal to
todays date

You don't write what you want to happen if NONE of those cells are equal
to
today's date. But this should get you started:

=IF(OR(B12:AL12=TODAY()),"Yes")

This formula must be **array-entered**:

----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. If you did this
correctly, Excel will place braces {...} around the formula.
--ron

Thank you very much its is woking like a sharm but whenever i am
putting it in a row that contains a #NUM! its is giving me num even if
there is todays date
ANY IDEAS ?

On Mon, 10 Aug 2009 04:48:01 -0700 (PDT), Tia wrote:

On Aug 10, 3:39*pm, Ron Rosenfeld wrote:
On Mon, 10 Aug 2009 04:16:07 -0700 (PDT), Tia wrote:
HELLO

I am looking for a if formula that shows yes one of B12: AL12 equal to
todays date

You don't write what you want to happen if NONE of those cells are equal to
today's date. *But this should get you started:

=IF(OR(B12:AL12=TODAY()),"Yes")

This formula must be **array-entered**:

----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. *If you did this
correctly, Excel will place braces {...} around the formula.
--ron

Thank you very much its is woking like a sharm but whenever i am
putting it in a row that contains a #NUM! its is giving me num even if
there is todays date
ANY IDEAS ?

Use Rick's suggestion:

=IF(COUNTIF(B12:AL12,TODAY()),"Yes","No")
--ron