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