I'm having trouble with a date formula. What I have is a column listing
the date, every two weeks. 05/14/2006, 05/28/2006, 06/11/2006, etc. I
need to lookup in that range, the cell containing the date that is less
than today.

In other words if today is less than 06/11/2006, then move up one cell
to 05/28/2006. Or if today is less than 05/28/2006, then move up one
cell to 05/14/2006.

Thanks in advance.

EP


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=548491