User Profile
HarryHuckerby
Copper Contributor
Joined Sep 18, 2023
User Widgets
Recent Discussions
Mapping data into a calendar on excel
Hi, I'm currently building an annual leave tracker whereby a power automate flow automatically populates an excel table with names and dates once a submisson is approved. Currently i have the data table and a 'calendar' dashboard in excel but I am unsure on the formulas needed to essentially map the annual leave data into the calendar. Currently what i want to do is include a H in the calendar for an annual leave day and a h for a half day. It currently looks like this, any help would be appreicated.
