ExcelBanter - between dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - between dates (https://www.excelbanter.com/excel-worksheet-functions/30319-between-dates.html)

Horacio

between dates

Hi!
How can I make the excel count between 2 dates?
Thanks
Horacio

Vasant Nanavati

If you want to count the days, just subtract the earlier date from the later
one.

--

Vasant

"Horacio" wrote in message
news:1118529210.527516@localhost...
Hi!
How can I make the excel count between 2 dates?
Thanks
Horacio

Peo Sjoblom

=COUNTIF(A2:A100,"="&DATE(y,m,d)-SUMIF(A2:A100,""&DATE(y,d,m)))

--
Regards,

Peo Sjoblom

(No private emails please)

"Horacio" wrote in message
news:1118529210.527516@localhost...
Hi!
How can I make the excel count between 2 dates?
Thanks
Horacio

All times are GMT +1. The time now is 07:09 PM.