Multiple If statements with multiple date range

[jaaakez99]

Trying to combine the following if statements into one so that the letter corresponding to the date range will display in the cell. Any suggestions?

=IF(OR(TODAY()>=E4,TODAY()<=F4),"E")
=IF(OR(TODAY()>=F4,TODAY()<=G4),"F")
=IF(OR(TODAY()>=G4,TODAY()<=H4),"G")
=IF(OR(TODAY()>=H4,TODAY()<=I4),"H")

[Bob Phillips]

Brte force

=IF(OR(TODAY()>=E4,TODAY()<=F4),"E",IF(OR(TODAY()>=F4,TODAY()<=G4),"F",IF(OR(TODAY()>=G4,TODAY()<=H4),"G",IF(OR(TODAY()>=H4,TODAY()<=I4),"H",""))))

[jaaakez99]

that worked, thank you! Is there a way though, to make it so the letter for the most current date appears?

[Bob Phillips]

Can you explain that a bit more, perhaps with an example?

[jaaakez99]

I have attached the file. I am new at this, so let me know if this isnt what you wanted. Thanks again.

[Bob Phillips]

Try

=INDEX(D1:M1,1,MATCH(TODAY(),D2:M2,1))

[jaaakez99]

that worked, thank you!