Hi! How can I make the excel count between 2 dates? Thanks Horacio
V Vasant Nanavati Jun 12, 2005 #2 If you want to count the days, just subtract the earlier date from the later one.
P Peo Sjoblom Jun 12, 2005 #3 =COUNTIF(A2:A100,">="&DATE(y,m,d)-SUMIF(A2:A100,">"&DATE(y,d,m))) -- Regards, Peo Sjoblom (No private emails please)
=COUNTIF(A2:A100,">="&DATE(y,m,d)-SUMIF(A2:A100,">"&DATE(y,d,m))) -- Regards, Peo Sjoblom (No private emails please)
