Hi, i saw your Youtube video on Dynamic Calendar [ https://youtu.be/KM3d8PSZvC0 ] and wanted to try on my own. However, i face a few issues which i hope you will be able to help. For my project i started in year 2025 instead of 2024.
(1) I need it to be only weekdays, start of week to be Mon, can this be done? I have tried with [=SEQUENCE(6,5,DATE(YEAR($AA$3),MONTH(DATEVALUE(B5&" 1")),1)-WEEKDAY(DATE(YEAR($AA$3),MONTH(DATEVALUE(B5&" 1")),1),2)+8-WEEKDAY(DATE(YEAR($AA$3),MONTH(DATEVALUE(B5&" 1")),1),2),1)]+ but it does not work?
(2) When i use the conditional formatting to highlight the holiday dates, those dates that was made to be "invisible" gets highlighted as such making it very confusing. Please help to advice how can this error be avoided?
Thank you so much for your kind attention.
Kind regards
kenneth Neo
1) Rather then modifying the working formulas in place, I would just hide the columns for Saturday and Sunday.
2) Not sure what you mean but I have applied the same conditional formats to the "Monday" calendar as the one starting on Sundays, and all seems to work as intended.
Please have a look at the attached file.
