I would like to design an excel workbook to track leave for Soldiers
in an effort to make sure that I have sufficient manpower to complete
all my missions. I would like it to do the following:

1. On sheet 1, input rank and name, leave start and end dates

2. Pass this information into a calendar on sheet 2 (already created)
by adding Soldier info to all days on which Soldier will be on leave

3. Subtract number of Soldiers who are on leave on a given date from
pool of available Soldiers which I can place either on sheet 1 or
another sheet

4. Compare Soldiers not on leave to manpower requirements to complete
platoon's missions and give either a YES or NO response to whether we
are mission capable.

I am currently deployed to Iraq and as you can imagine, do not have a
whole lot of time to try to figure this out alone so I am asking the
experts for help. Any that you can give will be greatly appreciated
by me and my Soldiers.