Retrieve User name if current date falls between user available dates

Greetings, I'm trying to pull a list of users that are available based on a given date range. For example;

User A has a start date of 5/13/13 and an end date of 9/18/13. I would like to be able to populate a list using current date and the comparison driver. So if today() is between those two dates grab that users name and pull it into the list. I have a list of 13 users that I need to do it for.

Thanks is advance.

Maybe I'm thinking of it too simply but I would try =IF(and(d2>b2,d2<c2),a2,"") where the name is in col A, the start dt is in col B, the end dt is in col C and "=Now()" is in col D.
Then you could compress the list in another column by using an advance filter.

It's worth a shot, somehow I was thinking that I had to use a vlookup or something. Thanks.

Sure, hope it works ok. =Today() also works in place of now in case you didn't know.
I tend to do things in a couple steps so I would do the formula, then copy paste special values then do the Advanced Filter and copy to another location the unique records only. Probably not as elegant as some would do but it'd work for me.