Excel: COUNTIF date

Question

Hello everyone,

I'm stuck on a silly issue with Excel.

So, I'm trying to count the number of cells in a range where the dates are before today (i.e., where the date has passed).
For the past hour, I've been unsuccessfully trying to combine the COUNTIF function with date calculations, like:
=COUNTIF(range,date<today />=COUNTIF(range,TODAY()-date>0)
etc...

I think it's the date format I'm entering into the function that isn't correct, but I'm not sure.

If someone could help me...

Thanks in advance!

Mike-31 · Accepted Answer

Hi,  =COUNTIF(A1:A48,"

michel_m · Answer

Hello,  Calculating with dates: hello Doliprane!  try this: =SUMPRODUCT((A1:B8

Larson · Answer

It works with both functions, except that the SUMPRODUCT function also counts empty cells (the function should consider that it’s < today...)

With Mike's solution, it's all good.

Thanks guys! I’ll be able to save some money on Paracetamol.

Mike-31 · Answer

No, empty cells are considered as 00/01/1900, but we can remedy that. However, in your calculation, they were considered as < today  A+

Excel: COUNTIF date < today

4 answers

The black swift flies for 10 months in a row without interruption

My pc won’t charge anymore and runs super slowly

Laptop: password forgotten

My second pc monitor

My computer stays connected for very little time

Unable to open xsl and xslx files

Pixma ts printer is broken

No internet connection possible

Print a page in the right orientation under windows 11

Change a contact’s ringtone