Forum Discussion
Inserting data from a separate spreadsheet into Calendar
Hi, I have an excel sheet which shows the dates, type and duration of my courses and I want to use this information to populate a calendar that I have made (will be on a separate excel document) for...
Hi
I use below formula to check whether each date in "Calendar" is between the Start Date and End Date of the course, and if it is, I will mark it with the course name.
(I attached an example spreadsheet, hope it helps).
=LET(courseInfo, XLOOKUP(C$1,CourseData!$A:$A,CourseData!$B:$D,"",0,1), startDate, INDEX(courseInfo,1,1),endDate, INDEX(courseInfo, 1, 2),IF(AND($A2>=startDate, $A2<=endDate), C$1, ""))