Hello,

I'm trying to write a formula to check if 4 different Status Symbols fall within certain dates, for example

Status Dates
Full is within 2 dates then type full
Half is within 2 dates then type half
special is within 2 dates then type special
Nil is within 2 dates then type nil

The forula I'm using is
=IF(AND($B$40<>0,B38<$G$40),"Full",IF(AND($B$42<>0,B38<$G$42),"Half",IF(AND($B$46<>0,B38<$G$46),"Special","Nil Pay")))

Is there a simpler way of doing this?

Thanks