Matching date between two columns having start and end date

[I2ufu5]

Hi,
I want to create a macro that matches a date to a specific period of time, based on two dates (start and end date of specific period).
As an input it gets a column containing dates and outputs two columns, first with that date and the second with value describing a period.

It also needs to load a file containing 3 columns, a start date, end date and description of periods and use it to match the dates with period description.

Are there any suggestions? I can also change the file containing periods if you have some other ideas.

Thanks

[afv2688]

Hello @I2ufu5 ,

Could you share an example of the expected inputs and outputs. Might help to clarify what you expect.

Regards

[pedrodrfaria · Accepted solution]

Hi @I2ufu5 

If I understood it correctly, you are looking for something similar to this:

Pedro.

[afv2688]

As per your description, this is what I think you want:

Regards