With Papershift's free excel leave planner you can get this done. However, we'll leave a word of caution. This is suitable for a team of 2-3 members. For small and medium-sized teams who plan on efficiency, we'd recommend you to try Papershift's leave planning software.