COUNTIF q re dates and blank cells

[Jock]

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

Thanks

 

[Dennis]

=COUNTIF(D3100,"<" & TODAY())

 

[Ron Coderre]

Try this:

=COUNTIF(D3100,"<"&TODAY())

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

Regards,

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

 

[Jock]

Nice one. Cheers Dennis
--
Traa Dy Liooar

Jock

=COUNTIF(D3100,"<" & TODAY())

 

[Jock]

Got it, thanks
--
Traa Dy Liooar

Jock

Try this:

=COUNTIF(D3100,"<"&TODAY())

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

Regards,

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