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"


--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=83292

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 wrote:

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"

--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=83292

--

Dave Peterson

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?




--
Cook
------------------------------------------------------------------------
Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=83292