Excel - If Forumula

[Allison.S]

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

 

[Mike H]

try this

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

Mike

 

[John C]

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

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

 

[T. Valko]

One way:

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