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
Bookmarks