Thread
:
"Between" dates in Excel
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
"Between" dates in Excel
try
=sumproduct((a2:a22b1)*(a2:a22<=b2))
--
Don Guillett
SalesAid Software
"Richie" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett