Formula Help (Date)
 

I need help with the following:

Cell A1 has the start date
Cell B1 has the estimted stop date
Cell A4 has a date in it - the cells below each have an expense in them for
that day.

I would like to have a formula enter a 1 in cell A24 if the date in cell A1
is = the date in cell A1 and is <= the value in cell B1. If it is out of
the date range between A1 & B1 then enter a "0"

Thanks,
Chance

try this assuming A4 is the date you are checking between date range
beginning in A1 and ending in B1

=IF(AND(A4=A1,A4<=B1),1,0)

"Chance224" wrote:

I need help with the following:

Cell A1 has the start date
Cell B1 has the estimted stop date
Cell A4 has a date in it - the cells below each have an expense in them for
that day.

I would like to have a formula enter a 1 in cell A24 if the date in cell A1
is = the date in cell A1 and is <= the value in cell B1. If it is out of
the date range between A1 & B1 then enter a "0"

Thanks,
Chance

I would like to have a formula enter a 1 in cell A24 if the date in cell
A1
is = the date in cell A1 and is <= the value in cell B1

Assuming that you meant ........cell B4 is =.......

Try

=(B4=A1)*(B4<=B1)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Chance224" wrote in message
...
I need help with the following:

Cell A1 has the start date
Cell B1 has the estimted stop date
Cell A4 has a date in it - the cells below each have an expense in them
for
that day.

I would like to have a formula enter a 1 in cell A24 if the date in cell
A1
is = the date in cell A1 and is <= the value in cell B1. If it is out of
the date range between A1 & B1 then enter a "0"

Thanks,
Chance

Just another option:

= --(AND(A4=A1,A4<=B1))

--
Dana DeLouis
Win XP & Office 2003


"Chance224" wrote in message
...
I need help with the following:

Cell A1 has the start date
Cell B1 has the estimted stop date
Cell A4 has a date in it - the cells below each have an expense in them
for
that day.

I would like to have a formula enter a 1 in cell A24 if the date in cell
A1
is = the date in cell A1 and is <= the value in cell B1. If it is out of
the date range between A1 & B1 then enter a "0"

Thanks,
Chance