I was given a formula (I don't understand it at all but it did what i needed at the time)
=IF(ISBLANK(F7)," ",INDEX($R$6:$R$59, MATCH(MIN(ABS($R$6:$R$59-$B$10)), ABS($R$6:$R$59-$B$10), 0)))
What it does ( I think) is look through a list of dates (R6:R59) for the nearest date to that in B10. Which was brilliant at the time but now I need to change it so that if the date it finds in the list is the same as B10 it moves to the date above it in the list. I still need it to do what it is already doing if the dates don't match.
I don't know if it is possible to alter the formula at all to make this happen.
Hopefully my explanation is understandable !!
Many thanks in advance
=IF(ISBLANK(F7)," ",INDEX($R$6:$R$59, MATCH(MIN(ABS($R$6:$R$59-$B$10)), ABS($R$6:$R$59-$B$10), 0)))
What it does ( I think) is look through a list of dates (R6:R59) for the nearest date to that in B10. Which was brilliant at the time but now I need to change it so that if the date it finds in the list is the same as B10 it moves to the date above it in the list. I still need it to do what it is already doing if the dates don't match.
I don't know if it is possible to alter the formula at all to make this happen.
Hopefully my explanation is understandable !!
Many thanks in advance
