countif a date is greater than today

K

Keith

Hi,
How can a range of cells that are dates be counted if the date in the cell
is prior to today.
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
K

Keith

Thanks!

Peo Sjoblom said:
=COUNTIF(Date_Range,"<"&TODAY())

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
Click to expand...
 
K

Keith

Thanks

Peo Sjoblom said:
=COUNTIF(Date_Range,"<"&TODAY())

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
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

Use TODAY() function as the criteria in a SUMIF formula 1
countifs Function not giving desired result with date criteria 2
Adding cells until they are greater than a lookup cell and returning a value 1
Show value from one cell in another cell if today falls between a date range 5
Using <= in countifs statement 1
Count IF 2
Countif or other formula needed for multiple data/critera results 3
Display weeks from a Milestone 0

Top