Good afternoon:

Currently working with a column filled with various dates. I'm looking for
a way to have a function written to count the amount of lines older than 20
or 30 days from current day for example.

Any assistance is appreciated. Thank you.

=COUNTIF(A1:A100,"<"&TODAY()-20)

--


Regards,


Peo Sjoblom

"Versace77" wrote in message
...
Good afternoon:

Currently working with a column filled with various dates. I'm looking
for
a way to have a function written to count the amount of lines older than
20
or 30 days from current day for example.

Any assistance is appreciated. Thank you.

Peo, Thanks for the prompt response. That's perfect.

Cheers,
Mike

"Peo Sjoblom" wrote:

=COUNTIF(A1:A100,"<"&TODAY()-20)

--


Regards,


Peo Sjoblom

"Versace77" wrote in message
...
Good afternoon:

Currently working with a column filled with various dates. I'm looking
for
a way to have a function written to count the amount of lines older than
20
or 30 days from current day for example.

Any assistance is appreciated. Thank you.

Hey the

Can someone explain why this happens: When i manually type the below
formula on my sheet the cell populates with a date. But when i copy the
formula below and paste it into the cell and change the range, i get the
count that i want.

Thanks.


"Peo Sjoblom" wrote:

=COUNTIF(A1:A100,"<"&TODAY()-20)

--


Regards,


Peo Sjoblom

"Versace77" wrote in message
...
Good afternoon:

Currently working with a column filled with various dates. I'm looking
for
a way to have a function written to count the amount of lines older than
20
or 30 days from current day for example.

Any assistance is appreciated. Thank you.

Excel tries to guess what format you want and will constantly change
them. It's often annoying, as the behavior varies with how you input
things, as you have noticed. Sometimes it seems random.

Change the format manually when it does this.