If between to dates enter "x"

[robocop1906]

Hello, trying to figure out a formula that would enter an "x" in the sell if a cells value is between two dates. I tried the follownig formulat below. Thanks


=if(and(D12>=1/1/2011,if(D12<1/31/2011,"X","")

 

[texasalynn]

try this

Excel Workbook
	E	F
2	1/1/2011	1/31/2011
3	X
Sheet1

Excel 2003

Cell Formulas
Range	Formula
E3	=IF(AND(D12>=E2,D12),"X","")

 

[Willmonbo]

I think you would be better off to put the conditions in a cell rather than in the formula itself, in this case I used cells G12 and H12 to put the start date and the end date.

=IF(AND(D12>=G12,D12<=H12),"X","")