When using excel, how to write equ to count dates.

Assume data is A1-A12

=COUNTIF(A1:A12,“＜=31/10/2006“)-COUNTIF(A1:A12,“＜1/10/2006“)

Count number of date less than 31/10 minus number of date before 1/10
i.e. date between 1/10 and 31/10.

2006-10-27 10:05:33 補充：
Please do not copy and paste the above formula, just retype it in the excel.I found the “ and ＜ in the above formula cannot be recognized in excel if using copy and paste function.

Firstly, change the cells into date format.
asuming that your have two columns, Col A containing the start date in A1, and Col B containing the end date in B1
try to type the following formula in C1
=datedif(A1, B1, "d")
this will calculate the days in between two dates
drag C1 to the columns


Remarks: yahoo 有錯體 d 之前和後有single quotation mark

hope this help

your range in simply contradicting.. what do you mean ??
好多方法..
here is one of the methods..
assume your data named 'date'
assume your start date at A19
assume your end data at A20

=COUNT(data)-COUNTIF(data,">"&A20) - COUNTIF(data,"<"&A19)

What is「equ to count total no. of dates」 means ??

Have you formated your 「Date」style? You try to right click ，Format Cell ，Number ，and then choose 「Date」select what format you need.

「count total no. of dates」, you try to use 「fx」 function and select you need.