COUNTIF q re dates and blank cells
 

I am trying to create a formula which will look at dates (D3:D100) and count
ones which are earlier than TODAY() but to ignore blank cells too.

Thanks
--
Traa Dy Liooar

Jock

COUNTIF q re dates and blank cells
 

=COUNTIF(D3:D100,"<" & TODAY())

"Jock" wrote:

I am trying to create a formula which will look at dates (D3:D100) and count
ones which are earlier than TODAY() but to ignore blank cells too.

Thanks
--
Traa Dy Liooar

Jock

COUNTIF q re dates and blank cells
 

Try this:

=COUNTIF(D3:D100,"<"&TODAY())

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Jock" wrote in message
...
I am trying to create a formula which will look at dates (D3:D100) and
count
ones which are earlier than TODAY() but to ignore blank cells too.

Thanks
--
Traa Dy Liooar

Jock

COUNTIF q re dates and blank cells
 

Nice one. Cheers Dennis
--
Traa Dy Liooar

Jock


"Dennis" wrote:

=COUNTIF(D3:D100,"<" & TODAY())

"Jock" wrote:

I am trying to create a formula which will look at dates (D3:D100) and count
ones which are earlier than TODAY() but to ignore blank cells too.

Thanks
--
Traa Dy Liooar

Jock

COUNTIF q re dates and blank cells
 

Got it, thanks
--
Traa Dy Liooar

Jock


"Ron Coderre" wrote:

Try this:

=COUNTIF(D3:D100,"<"&TODAY())

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Jock" wrote in message
...
I am trying to create a formula which will look at dates (D3:D100) and
count
ones which are earlier than TODAY() but to ignore blank cells too.

Thanks
--
Traa Dy Liooar

Jock