Forum Discussion

tkelly0823's avatar
tkelly0823
Copper Contributor
May 14, 2020
Solved

Task Calendar

I am using a Holiday Template and trying to adapt it to a task calendar.  The calendars are the 12 months on their own tabs and can be modified to display any time frame.  There is also a Holidays ta...
excel
Formulas and Functions
  • peteryac60's avatar
    peteryac60
    May 17, 2020

    tkelly0823 

    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

     

     

tkelly0823's avatar
tkelly0823
Copper Contributor
May 18, 2020

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.

peteryac60's avatar
peteryac60
Iron Contributor
May 18, 2020

tkelly0823 

 

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

Resources