HI Vasant
Sorry for the late reply thanks you very much for the effort,.
Like to tell you that everything is perfect except one change need to do is
that when ever Emp taken leaves continuously like say (15th June to
23rdJune ) so when I click for output it should give me only one entry
but
Hi All,
I am having 1 Excel sheet which contains 3 sheets
In sheet1 main database i have to update in every month for Leave
calculation
In Sheet2 I have to find out the total leaves taken in that month with dates
of IL NCNS Staus from Sheet 1 (details given in attached sheet)
In sheet3 i have