A code to remove any existing content in an automatic calendar

Need assistance as soon as possible. I have an automatic Leave Calendar and when I put a number in a cell, that number shows up in all the cells for that date. For example I put the number 8 in for April 10 2015, and that number is showing up for every month on the 10th as well as every year. I just want that number in that on cell. See attached Calendar.

Thank You!

I think you need to record the dates of the holidays booked in a separate sheet, and then display them on a calendar sheet. Here's two that I have submitted a few years ago (the OP changed their mind on how they wanted them to be displayed).

Hope this helps.

Pete