Indeed it is, and without an INDIRECT as an added bonus.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"daddylonglegs"
wrote in message
news:daddylonglegs.2cytxj_1156290612.9001@excelfor um-nospam.com...

Perhaps easier to use

=B1-TODAY()+SUMPRODUCT(--(M1:M10=TODAY()),--(M1:M10<=B1))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=574137