searching thorugh dates

[mr_nice!]

Sorry about the title being so crap.If someone can think of a better
name I will edit this post so it is more useful.

I am playing with excel a bit and trying to make a holiday card shown
in the example.

Between two dates I have holiday entitlement (left hand side of the
example) and what I would like to do is when I type in the day off
(right hand side of the example) it updates how much holiday has been
taken.

In the example the there are 3 days which fall between 20/12/05 and
28/02/06 and therefore I would cell A be 3. The row below would say two
any ideas

nice


+-------------------------------------------------------------------+
|Filename: example.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4144 |
+-------------------------------------------------------------------+

 

[JAVB]

Try the following formulas:
in Cell "A" enter: =COUNTIF(F4:F18,">0") Column F would be the rang
of cells where the date of vacation day is entered.
in the cell below "A" enter: =IF(E4>D4,0,COUNTIF(F4:F18,">0")-E4)
E4 would be "A