Create recurring calendar from Excel file

Like (0) Share

Report

Posted on 2 Mar 2022 18:49:48 by Community Power Pla...

Ok, sorry for the vague title but here's the basics: We have an Excel file that uses the EDATE function to create a list of dates after we enter the start date. So for example, if I enter "March 2nd 2022" in cell A1, EDATE will then populate dates 3 months, 6 months, and 9 months out in cells A2, A3, and A4. What I would like to do is to somehow connect those dates to a calendar. So the ideal state would be: I enter a date in A1. EDATE populates the followup dates based on A1 and spits them out in A2, A3, and A4. Then, a Power Automate flow would take all of the dates listed and create a calendar event (ideally a shared calendar, like on SharePoint) for each one. Does anyone have any ideas?