• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Comment


i want to have a tab with a monthly calendar and another tab for employees leaves and when selecting employee from the drop-down menu,i got comments automatically on dates with leaves on the calendar from leave logs, and this can be changed based on employe selected,is that possible and what can i use to do it


Peter Bartholomew

Well-Known Member
COUNTIFS will test each day of the active calendar to test the day against start and end dates for leave recorded for the given employee.
thanks for this sample, yes its exactly what I want to do
thanks again, please allow me to send it here again if i have a side questions after I apply it to the whole workbook