Using COUNTIF and NOW() together
 

Having problems with this one.
Column B has sequential dates entered. I would like to find out how many are
today's date so I tried this:
COUNTIF(b5:b100,=now())
Results in 0 as Excel changes it to this: COUNTIF(b5:b100,"=now()") and
looks for text.

Any ideas?
--
tia

Jock

Using COUNTIF and NOW() together
 

COUNTIF(B5:B100,"="&TODAY())

"Jock" wrote:

Having problems with this one.
Column B has sequential dates entered. I would like to find out how many are
today's date so I tried this:
COUNTIF(b5:b100,=now())
Results in 0 as Excel changes it to this: COUNTIF(b5:b100,"=now()") and
looks for text.

Any ideas?
--
tia

Jock

Using COUNTIF and NOW() together
 

Use TODAY() instead, and frame it up like this:
=COUNTIF(B5:B100,TODAY())
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jock" wrote:
Having problems with this one.
Column B has sequential dates entered. I would like to find out how many are
today's date so I tried this:
COUNTIF(b5:b100,=now())
Results in 0 as Excel changes it to this: COUNTIF(b5:b100,"=now()") and
looks for text.

Any ideas?
--
tia

Jock

Using COUNTIF and NOW() together
 

Thanks to both Teethless Mama (good name there) and Max
Job done

Jock


"Jock" wrote:

Having problems with this one.
Column B has sequential dates entered. I would like to find out how many are
today's date so I tried this:
COUNTIF(b5:b100,=now())
Results in 0 as Excel changes it to this: COUNTIF(b5:b100,"=now()") and
looks for text.

Any ideas?
--
tia

Jock

Using COUNTIF and NOW() together
 

welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jock" wrote in message
...
Thanks to both Teethless Mama (good name there) and Max
Job done

Jock