Forum Discussion
Task Calendar
Hi
I am not sure that you can do this simply by formula - I would recommend writing a VBA routine but.....
If you want to try the formula approach I would suggest that you look to using the FILTER command which allows you to filter the date in your holiday table. For example 29th June 2020 has 3 entries; you could then concatenate the entries together. Unfortunately this will probably make your formula even more complicated than it is already!
To write VBA you will need to invest a bit of time to getting it working!
BTW - I would recommend you sort your holiday table in date order.
Hope this helps and good luck!
Peter
Hi
I am not sure that you can do this simply by formula - I would recommend writing a VBA routine but.....
If you want to try the formula approach I would suggest that you look to using the FILTER command which allows you to filter the date in your holiday table. For example 29th June 2020 has 3 entries; you could then concatenate the entries together. Unfortunately this will probably make your formula even more complicated than it is already!
To write VBA you will need to invest a bit of time to getting it working!
BTW - I would recommend you sort your holiday table in date order.
Hope this helps and good luck!
Peter
peteryac60Thank you. I have since organized my "holidays", glad to know I am on the right track there. I will give filter a try and if I need to move to VBA, will spend some time there. Thanks again.
Glad to hear you are moving in the right direction!
I'd be grateful if you would mark the solution as complete!
many thanks,
Peter
