Hi,

I'm not clear on what 12/18/08 and 2/13/09 have to do with your arrangement.
I though you were trying to find out if 1/19/2009 was between 1/5/09 and
1/12/09?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Liz C" wrote:

I don't see in your formula how it takes the date in F1 into account.

I have week starting dates across the top and employees with scheduled work
start and end dates down the side. I want to put a "1" in the cells for the
weeks they work. Like below:
start end 1/5/09 1/12/09
1/19/09
fred smith 12/18/08 2/13/09 1 1 1

I really appreciate your help.

Liz

"Liz C" wrote:

I have week beginning dates in row 1 starting on F, Work Start dates in
column D, and Work End dates in column E.

How can I get it in cell F2 to put a "1" if the work start and end dates
fall within the week in F?

Thanks again for your help!

Liz