E
edwardpestian
I'm having trouble with a date formula. What I have is a column listin
the date, every two weeks. 05/14/2006, 05/28/2006, 06/11/2006, etc.
need to lookup in that range, the cell containing the date that is les
than today.
In other words if today is less than 06/11/2006, then move up one cel
to 05/28/2006. Or if today is less than 05/28/2006, then move up on
cell to 05/14/2006.
Thanks in advance.
E
the date, every two weeks. 05/14/2006, 05/28/2006, 06/11/2006, etc.
need to lookup in that range, the cell containing the date that is les
than today.
In other words if today is less than 06/11/2006, then move up one cel
to 05/28/2006. Or if today is less than 05/28/2006, then move up on
cell to 05/14/2006.
Thanks in advance.
E