If statements

[lionstud31]

is it possible to do an if statement between two dates? For Example: between jan 3rd 2006 and feb 2nd 2006 would make it true, any other dates would make it false.

 

[Richard Schollar]

Say the date you are interested in is in A1, the jan3rd date is in B1 and the Feb2nd date is in C1 then:

=AND(A1>=B1,A1<=C1)

Best regards

Richard

EDIT: with IF maybe:

=IF(AND(A1>=B1,A1<=C1),TRUE,FALSE)

but the IF is unnecessary.

 

[Andrew Poulsom]

See if you can adapt this:

=AND(DATE(2006,1,15)>=DATE(2006,1,3),DATE(2006,1,15)<=DATE(2006,2,2))

 

[Aladin Akyurek]

Try to avoid using "statement" when you mean formula...

=AND(A2>=X2,A2<=Y2)

where X2 <= Y2 which are date criteria of interest.

 

[lionstud31]

I dont understand... What if I want total sales (which is in column C) only if it is between the dates of Jan 3, 2006 and Feb 2, 2006 (which is in column B).

 

[buckley22]

Say the date you are interested in is in A1, the jan3rd date is in B1 and the Feb2nd date is in C1 then:

=AND(A1>=B1,A1<=C1)

Best regards

Richard

EDIT: with IF maybe:

=IF(AND(A1>=B1,A1<=C1),TRUE,FALSE)

but the IF is unnecessary.

Richard has already given you the answer my friend

in his IF option simply replace TRUE with the cell containing the sale in question, replace FALSe with "", et voila all the sales between those dates are filtered out and those outside the limits are turned into nothing....then SUM this column and you have your answer.

You could even have you date limit Cells and entry cells and then you can filter out any dates you want in an instance

 

[lionstud31]

thanks yall, problem solved

 

[Andrew Poulsom]

I think what you want is something like:

=SUMPRODUCT(--(B1:B1000>=DATE(2006,1,3)),--(B1:B1000<=DATE(2006,2,2)),C1:C1000)

You can use cell references in place of eg DATE(2006,1,3).

 

[Richard Schollar]

LionStud

Do you have a range of sales dates and sales values, and you want to sum those between the given dates? If so, something like this might be more approrpiate:<SPAN id='ForSubmit'>

Book2.xls
	A	B	C	D
1	Date	Sales
2	01January2006	10
3	15January2006	15
4	01February2006	20
5	15February2006	13
6	01March2006	14
7	15March2006	16
8	01April2006	18
9	15April2006	17
10
11	Date1:	29January2006
12	Date2:	17March2006
13	SalesBetween:	63
Sheet1

</SPAN>

Hope this helps!

Richard

EDIT: Man I am soooooooooo slow at times