X
X
Xambey2018-10-17 02:13:58
excel
Xambey, 2018-10-17 02:13:58

How to count the number of cells with dates having a value less than the date whose value is stored in an outer cell in Excel?

Formula. How to count the number of cells with dates having a value less than the date whose value is stored in an outer cell in Excel?
Here's what I found: COUNTIF(range; "<01.10.18") - this formula works, but how to take the date value from any cell in this case?
Give examples please.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
DS28, 2018-10-17
@Xambey

"<01.10.18" replace with "<"&cell reference.
For example COUNTIF(range; "<"&A1)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question