Dates can be a really big pain.  Are you using javascript or java? 

Post your code to this point 

Many thanks for the prompt reply.

I am trying to implement using SSJS. 

Baxter Jimuk, You are completely right what i am planning to do.

Typically what i do is figure out the formula I need first in the Notes Client.  Just search the view in the database.  That's pretty much the same formula you'll use with the domino object model in SSJS.  You would just need to turn it into a proper string and pass into a search method.

Suggest you get the formula first - get it working then tackle the SSJS.

Thanks for all,

I got it from below link.

http://stackoverflow.com/questions/16352792/check-date-range-vs-some-other-date-ranges-for-missing-days

var dateArray = new Array();

//Get the date
var AbsenctSince:NotesDateTime = session.createDateTime(document1.getItemValue("from").toString().substr(0,19));
var endDate:NotesDateTime = session.createDateTime(document1.getItemValue("to").toString().substr(0,19));

//Get all days between two dates
dateArray = getDates(AbsenctSince, endDate);

and then add below function code,

function getDates(startDate:NotesDateTime, endDate:NotesDateTime)
{
    var dateArray = new Array();
    var currentDate:NotesDateTime = startDate;
    while (endDate.timeDifference(currentDate) > -1)
    {
        dateArray.push( currentDate.getDateOnly() );
        currentDate.adjustDay(1);
    }
    return dateArray;
}