So i have looked over and over for a proper answer on this, but I am having a hard time piecing everyone else's formula together into mine, if Someone could help me with the formula it would be much appreciated.
Basically its a form that says weather someone is suspended or on Leave of Absence or neither and relays it to our roster.
E F G H I
LOA / Suspended Your Name Their Name Start Date End Date

Currently the Formula i have is 
=IF(AND(TODAY()>=H2,TODAY()<=I2),I2,"")
(If todays date is between start and end date show end date)
Which does a okay job at telling me if they are currently on LOA, and returns the ending date.
Now im adding suspended to this form, so i need to Add
If E = "LOA" Then IF(AND(TODAY()>=H2,TODAY()<=I2),"LOA"I2,"" (If E says LOA Then check if Todays date is between start and end and if it is show "LOA" End Date)
Otherwise see if
If E = "Suspended Then IF(AND(TODAY()>=H2,TODAY()<=I2),"SUSPENDED"I2,"" (If E says Suspended Then check if Todays date is between start and end and if it is show "Suspended" End Date

I understand the code may need to be written but i can't seem to find a method in doing this.
Thank you