Formula question

[Cook]

how do I turn the following into a formula?

If column J of sheet "hicap-09" is greater than or equal to 3/16/09 and
is less than or equal to 3/21, if yes "1", if no than "0"

 

[Dave Peterson]

What cell in column J?

I used J99:

=if(and('hicap-09'!J99>=date(2009,3,16),'hicap-09'!j99<=date(2009,3,21)),1,0)

Actually, you don't need the if portion:

=--(and('hicap-09'!J99>=date(2009,3,16),'hicap-09'!j99<=date(2009,3,21)))

The rightmost - sign changes true to -1 and the leftmost - sign changes -1 to 1.

And --(false) will be 0.

 

[Cook]

I guess what I am really trying to do is add on (hicap-09) the number of
"FULL JOBS" (COLUMN C), written by "A. BERNARDI" (COLUMN G) and
completed between two specific dates (CELLS B1&B2 ON sheet1, COLUMN J ON
hicap-09) and put that number in cell B3 of "sheet1".

Does this make sense?