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)


If you're using Excel 365, this may work for you:




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!