Dana -

Thanks for the help. I think that solution will work. One furthe
question:

Would it be possible to restrict the formula to one cell, and just hav
it return the most recent x day min? My spreadsheet is gettin
extremely complicated, and I want to avoid having to change reference
in macros already written. Thanks again.

-Pau

--
Paul98
-----------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...fo&userid=2485
View this thread: http://www.excelforum.com/showthread.php?threadid=38751