Excel formula assistance for If Text

[maryg1118]

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!!

[#2 · Accepted solution]

@maryg1118 

If 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.

[#3]

Thanks, @Patrick2788! This is exactly what I was looking for. I appreciate your help!

[#4]

You are welcome!