Return Column title for table dates

Hello guys,

i have table with multiple columns and multiple row that have dates for them like the table below:

	Start	First Half	Second Half	End
V1	20-Apr-17	23-Apr-17	27-Apr-17	30-Apr-17
V2	20-May-17	23-May-17	27-May-17	30-May-17
V3	20-Jun-17	23-Jun-17	27-Jun-17	30-Jun-17
V4	20-Jul-17	23-Jul-17	27-Jul-17	30-Jul-17

Based on the current date and cell X10(that contains one of the items from the first column of the above table (V1-V4)) to return the column name
- If the date is between "Start" and "First Half" the result should be "Start" and so on

Thanks

Try

=IFERROR(INDEX($B$1:$E$1,MATCH(TODAY(),INDEX($B$2:$E$4,MATCH($X$10,$A$2:$A$4,0),0),1)),"")

See attached.

Thank you John.

It works perfectly