On Mon, 5 Jun 2006 03:30:02 -0500, edwardpestian
wrote:


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

A simple VLOOKUP formula should do that:

=VLOOKUP(TODAY(),DateRangeList,1)


--ron