Forum Discussion
Solved
Excel formula assistance for If Text
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!!
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.
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!
