Hi Liz,

Assuming that your week refers to 7 days, change 7 to 5
if yours is a 5-day week
try this formula in F2 and copy down as far as your data is.
This will put a 1 into F2 if the start and end dates
fall within the week and a blank if otherwise.

=IF(E2-D2<=7,1,"")

Does this do what you want?
Pls post back if not

HTH
--
If this posting is helpful, appreciate that you click on the Yes button below

Thank You

cheers, francis



"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