Nov 23 2022 06:16 AM
Hi, I am trying to create a simple calendar template where the calendar events populate in a separate column. So if there is a calendar event on January 1, I would like for the event list to populate with the date, time (if applicable) and the event information. I have found a clunky way to do this and know there is a simple way to do it where there aren't empty fields in the event list and I can replicate this for each month (separate tabs). Can someone please help? Thanks!!
Nov 23 2022 07:13 AM
SolutionIf you're using Excel 365, this may work for you:
=LET(NovDays,WRAPROWS(TOROW(November,,1),2),FILTER(NovDays,TAKE(NovDays,,-1)<>0))
I've added the above to an Office online calendar template that's similar to your arrangement.
Nov 23 2022 08:47 AM
Nov 23 2022 07:13 AM
SolutionIf you're using Excel 365, this may work for you:
=LET(NovDays,WRAPROWS(TOROW(November,,1),2),FILTER(NovDays,TAKE(NovDays,,-1)<>0))
I've added the above to an Office online calendar template that's similar to your arrangement.