Counting of dates before today

  • Thread starter Thread starter JanH
  • Start date Start date
J

JanH

In an Excel sheet I have one row with dates. Can I use the counti
formula to calculate how many of those dates are in the past (befor
today)?

Any help is very welcome.

Regards, Ja
 
Frank

How would I do that with a date, i.e. let's say range A1:A100 anything after 1/1

Vielen Dank
pepenach

----- Frank Kabel wrote: ----

H
tr
=COUNTIF(A1:A100,"<" & TODAY()
 
One way

=COUNTIF(A1:A100,"<" & --"01/15/04")

or better

=COUNTIF(A1:A100,"<" &DATE(2004,1,15))

the latter is not regional setting dependent

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Or if you want to be picky and pick the dates after 2004-01-15:
=COUNTIF(A1:A100,">" &DATE(2004,1,15))
You could use instead:
=COUNTIF(A:A,">" &DATE(2004,1,15))


Peo Sjoblom said:
=COUNTIF(A1:A100,"<" &DATE(2004,1,15))

not regional setting dependent
Click to expand...
=
 
Hi Peo

Peo Sjoblom said:
One way

=COUNTIF(A1:A100,"<" & --"01/15/04")
Click to expand...

won't work in a non English environment with other date separators :-)
So your other solution is much better. What should work also for non
english versions is
=COUNTIF(A1:A100,"<" & --"2004-01-15")

Regards
Frank
 
Back
Top