ExcelBanter - countif a date is greater than today

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - countif a date is greater than today (https://www.excelbanter.com/excel-worksheet-functions/9063-countif-date-greater-than-today.html)

Keith

countif a date is greater than today

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

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

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

"Keith" wrote in message
...
Hi,
How can a range of cells that are dates be counted if the date in the cell
is prior to today.
--
Keith

Keith

Thanks!

"Peo Sjoblom" wrote in message
...
=COUNTIF(Date_Range,"<"&TODAY())

--
Regards,

Peo Sjoblom

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

"Keith" wrote in message
...
Hi,
How can a range of cells that are dates be counted if the date in the
cell
is prior to today.
--
Keith

Keith

Thanks

"Peo Sjoblom" wrote in message
...
=COUNTIF(Date_Range,"<"&TODAY())

--
Regards,

Peo Sjoblom

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

"Keith" wrote in message
...
Hi,
How can a range of cells that are dates be counted if the date in the
cell
is prior to today.
--
Keith

All times are GMT +1. The time now is 05:21 PM.