N
Nokose451
Hello all. I hope someone can help me figure this one out. So here w
go....
I have a spread sheet that you plug in a date and then enter anothe
date manually. The second date is the on I would like to automate.
need the first date to be complared in a range of dates and then retur
the effective date.
Example:
Entered date - 01/08/2006
Range Table: Effective:
01/01/2006 - 01/05/2006 01/05/2006
01/06/2006 - 01/10/2006 01/10/2006
01/11/2006 - 01/15/2006 01/15/2006
I would like it to return the 01/10/2006 effective date for that range
Any help is appreciated
go....
I have a spread sheet that you plug in a date and then enter anothe
date manually. The second date is the on I would like to automate.
need the first date to be complared in a range of dates and then retur
the effective date.
Example:
Entered date - 01/08/2006
Range Table: Effective:
01/01/2006 - 01/05/2006 01/05/2006
01/06/2006 - 01/10/2006 01/10/2006
01/11/2006 - 01/15/2006 01/15/2006
I would like it to return the 01/10/2006 effective date for that range
Any help is appreciated