Gathering Count by date

  • Thread starter Thread starter Versace77
  • Start date Start 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.
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
formulas to count dates 2
Excel Average dates help 0
calculating months between dates 4
count dates 4
Sorting amounts in columns by due dates 7
Excel Colour code dates 1
How do I count differert items in a column only if the date in an. 6

Back
Top