How to find todate date lie between from and to date

[neha_sri]

Hi All,

I have employees allocation data.

Emp No	Allocation start date	Allocation end date
121	01-01-2014	01-02-2015
122	05-01-2015	22-02-2015
123	01-01-2015	20-02-2015
123	22-02-2015	25-03-2015

Now I want to see  that today date lies between allocation start date and allocation end date.

I also want a new column that contains count of days on which particular employee is not allocated

and latest date of  not allocated.

Regards,

Neha