Hello I have a dataset where there are three columns with dates. Column A contains a start date, Column B contains an end date and Column C contains the event date. I would only want to retain the rows of data in which the Event Date (Column C) falls between the Start Date (Column A) and End Date (Column B).
For example, the data I have:
ID A B C
1 10JAN19 06FEB19 01JAN19
2 02JAN19 27FEB19 31JAN19
3 09JAN19 03MAR19 26FEB19
4 12JAN19 19APR19 30JUN19
5 30JAN19 20MAR19 29APR19
And the data I want:
ID A B C
2 02JAN19 27FEB19 31JAN19
3 09JAN19 03MAR19 26FEB19
Any help appreciated 🙂 thank you