Matching date between two columns having start and end date

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

Datasets

Macros

Date Time

Join

Accepted answers

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

Pedro.

Matching date between two columns having start and end date.yxmc

All comments

Hello @I2ufu5 ,

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

Regards

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

Pedro.

Matching date between two columns having start and end date.yxmc

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

Regards

matching_dates.yxmd

Quick Links

Tags

This months top contributors

Hollingsworth 335