Badly need help on this one . I need to either v lookup or if any other formula works , count the no of days in between two days (if the holiday date mentioned in the period is between the leave days ).
For example a person avails leave between 01 Jan 2013 to 30 Jan 2013 and there is a Holiday on 27th of Jan ( doesn't matter if its a weekend or weekday ) . Is there a way if we can get this by formula
Request your help on this.