If my cut off date was 7/22, any date before or on that date, i.e. 7/22,
7/21, 5/30, etc., would populate Cell D1 with the number that is in Cell
C1.

Does that help?


--
Phatbob
------------------------------------------------------------------------
Phatbob's Profile: http://www.excelforum.com/member.php...o&userid=34371
View this thread: http://www.excelforum.com/showthread...hreadid=541494