Requesting help with a calendar that will auto-populate from a data set

Hi there,
In Your template file, You have 'Start' & 'Finish' date.
Do You want to use booth dates, or only the Start date?
In calendar sheet, do You want to filter by Resource name, or also other columns?
The resources name are random combination of names, do You want to filter by one name from each string, or combination?
(for example: row4: 'Mer, MR, Des' - filter by one of them, combination or entire string as it is?)

Hi there,
So here it is...
- DropDown menu for year & month selection
- Forms - optionbuttons for category selection.

Mail calendar:
formula for building calendar days:

Formula:

Please Login or Register  to view this content.

array formula for getting entries that match calenday day & category:

Formula:

Please Login or Register  to view this content.

Maybe it can be done shorter, but this is done without any helper columns (which btw are in the calendar You provide with link).

Calendar is build only for 5 entries (matches) per day. If there are more matches, You can see that in smaller calendar on the right of the main one (day & number of matches) - You have to filter that manualy in database.

If You have some general tasks and do not want to display them in calendar, but still want to have them marked in database sheet, You can use any other character than 'X'.

So check that and let me know if this is what You are looking for...

Copy of S16 Calendar REVAMP.xlsx

(btw sorry for late response, but I am bussy at work)

You have to replace every semicoma in every formula with coma or wait 2hours and I will send fixed file

send from my xperia z via tapatalk

...hey... I am not able to replace semicomas without getting an error msg on the formula.
Try it by replacing with Ctrl+H in the calendar sheet. It should work. Also go to Formulas tab, and replace semicoma with coma in all named ranges.

Hope it will work!