Excel: COUNTIF date < today
Solved
Larson
-
POUAPRENDRE -
POUAPRENDRE -
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!
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!
4 réponses
Hi,
=COUNTIF(A1:A48,"<"&TODAY())
See you later
__________________________________________________________________
Need help. In the forum, volunteers take the time to decipher your sometimes confusing explanations and offer their knowledge.
Once a solution is found, please have the courtesy to mark your status as resolved. This way, your problem can be categorized and serve as a reference for others with similar cases.
=COUNTIF(A1:A48,"<"&TODAY())
See you later
__________________________________________________________________
Need help. In the forum, volunteers take the time to decipher your sometimes confusing explanations and offer their knowledge.
Once a solution is found, please have the courtesy to mark your status as resolved. This way, your problem can be categorized and serve as a reference for others with similar cases.
POUAPRENDRE
Thank you for this very simple formula. An old question but one that solves an issue for me today. Good luck.