Try this.

=SUMPRODUCT(--(DATEDIF(B2:B5,TODAY(),"d")+1=120))

B2:B5 are your dates. DATEDIF counts the days between the date in your
dates and TODAY. Add the 1 to include the start date.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=513244