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
Solved! Go to Solution.
Hello @I2ufu5 ,
Could you share an example of the expected inputs and outputs. Might help to clarify what you expect.
Regards