IF date formula

  • Thread starter Thread starter Tia
  • Start date Start date
HELLO

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

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
 
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
Click to expand...

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)


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
Click to expand...

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 ?
 
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 ?
Click to expand...

Use Rick's suggestion:

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