Forum Discussion

maryg1118's avatar
maryg1118
Copper Contributor
Nov 23, 2022
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...
excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Nov 23, 2022

    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.

     

maryg1118's avatar
maryg1118
Copper Contributor
Nov 23, 2022
Thanks, Patrick2788! This is exactly what I was looking for. I appreciate your help!
Patrick2788's avatar
Patrick2788
Silver Contributor
Nov 23, 2022
You are welcome!

Resources