We are attempting to create a formula to state whether a cell is between two
dates.

eg.

Cell (A1) Information = 01/08/08
Cell (B1) information = £70

need IF instruction to state that if cell (A1) is between 01/08/08 and
31/08/08 then return the value of cell (B1), if not then return the value of
£0

Is anyone able to provide the formular for this?

Thanks

Allison

try this

=IF(AND(A1=DATE(2008,8,1),A1<=DATE(2008,8,31)),B1 ,0)

Mike

"Allison.S" wrote:

We are attempting to create a formula to state whether a cell is between two
dates.

eg.

Cell (A1) Information = 01/08/08
Cell (B1) information = £70

need IF instruction to state that if cell (A1) is between 01/08/08 and
31/08/08 then return the value of cell (B1), if not then return the value of
£0

Is anyone able to provide the formular for this?

Thanks

Allison

=(A1=startdate)*(A1<=enddate)*B1

NOTE: This assumes that startdate and enddate are valid dates.
--
John C


"Allison.S" wrote:

We are attempting to create a formula to state whether a cell is between two
dates.

eg.

Cell (A1) Information = 01/08/08
Cell (B1) information = £70

need IF instruction to state that if cell (A1) is between 01/08/08 and
31/08/08 then return the value of cell (B1), if not then return the value of
£0

Is anyone able to provide the formular for this?

Thanks

Allison

One way:

=AND(A1=DATE(2008,8,1),A1<=DATE(2008,8,31))*B1

--
Biff
Microsoft Excel MVP


"Allison.S" wrote in message
...
We are attempting to create a formula to state whether a cell is between
two
dates.

eg.

Cell (A1) Information = 01/08/08
Cell (B1) information = £70

need IF instruction to state that if cell (A1) is between 01/08/08 and
31/08/08 then return the value of cell (B1), if not then return the value
of
£0

Is anyone able to provide the formular for this?

Thanks

Allison

Just another option, with 1/8/08 in A1 and 31/8/08 in B2:

=IF((MEDIAN(A2,B2,A1)=A1),B1,"Not in range")

or

=(MEDIAN(A2,B2,A1)=A1)*B1


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Allison.S" wrote in message
...
We are attempting to create a formula to state whether a cell is between
two
dates.

eg.

Cell (A1) Information = 01/08/08
Cell (B1) information = £70

need IF instruction to state that if cell (A1) is between 01/08/08 and
31/08/08 then return the value of cell (B1), if not then return the value
of
£0

Is anyone able to provide the formular for this?

Thanks

Allison

=IF(AND(MONTH(A1)=8,YEAR(A1)=2008),B1,0)
or (if you put your date limits in D1 and E1)
=IF(AND(A1=D$1,A1<=E$1),B1,0)
--
David Biddulph


"Allison.S" wrote in message
...
We are attempting to create a formula to state whether a cell is between
two
dates.

eg.

Cell (A1) Information = 01/08/08
Cell (B1) information = £70

need IF instruction to state that if cell (A1) is between 01/08/08 and
31/08/08 then return the value of cell (B1), if not then return the value
of
£0

Is anyone able to provide the formular for this?

Thanks

Allison