Gathering Count by date

V

Versace77

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.
 
V

Versace77

Hey there:

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.
 
S

Spiky

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.
 
Top