COUNTIF q re dates and blank cells

  • Thread starter Thread starter Jock
  • Start date Start date
J

Jock

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
 
Try this:

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

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

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Got it, thanks
--
Traa Dy Liooar

Jock


Ron Coderre said:
Try this:

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

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

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Countif statement using dates 15
Excel Need Countifs Formula Help 0
Count IF 1
Excel Average dates help 0
Excel Concatenate with line breaks but ignore blank cells 3
Excel Formula - Count Dates from another Sheet 8

Back
Top