SOLVED

Excel formula assistance for If Text

New Contributor

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

 

2022-11-23 (1).png

3 Replies
best response confirmed by Hans Vogelaar (MVP)
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.

 

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