"Between" dates in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a column of dates in a worksheet and I need to find how many dates
are between 2 dates specified (probably month / quater end dates).

In Access I would use the between command, but how can I do this in Excel?
 
This example counts day in May 2007:-

=COUNTIF(A1:A100,"<="&DATE(2007,5,31))-COUNTIF(A1:A100,"<"&DATE(2007,5,1))

Mike
 
You must log in or register to reply here.

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 Help with dates 2
Update cell value based on name and specific date 1
Calculate elapsed time excluding specific timeframe 10
Difference System date and Excel Date function 2
countifs Function not giving desired result with date criteria 2
Difference betwen Excel Date () Function and System Date 2
Excel Average dates help 0
Pivot table macro filter data between yesterday and today (date+time) 0

Back
Top