Using if statement to select dates

[HC7531]

Good Afternoon:

I am working in MS Office 2010 and I am trying to select all dates from a column of dates that fall within a defined period of time:

September 1st, 2010 to August 31st, 2011.

In a separate column, I simply want to populate the column with the word "yes" once excel has identified whether the dates fall within my timeframe.

I don't expect every row to be populated with a "yes" in my new column as many dates are old.

Clearly, I am having difficulty writing the logive for my request and would be gratefule for any assistance that you can provide.

Much appreciated,

CH

 

[HC7531]

Good Afternoon:

I am working in MS Office 2010 and I am trying to select all dates from a column of dates that fall within a defined period of time:

September 1st, 2010 to August 31st, 2011.

In a separate column, I simply want to populate the column with the word "yes" once excel has identified whether the dates fall within my timeframe.

I don't expect every row to be populated with a "yes" in my new column as many dates are old.

Clearly, I am having difficulty writing the logive for my request and would be gratefule for any assistance that you can provide.

Much appreciated,

CH

 

[T. Valko]

Good Afternoon:

I am working in MS Office 2010 and I am trying to select all dates from a column of dates that fall within a defined period of time:

September 1st, 2010 to August 31st, 2011.

In a separate column, I simply want to populate the column with the word "yes" once excel has identified whether the dates fall within my timeframe.

I don't expect every row to be populated with a "yes" in my new column as many dates are old.

Clearly, I am having difficulty writing the logive for my request and would be gratefule for any assistance that you can provide.

Much appreciated,

CH

Try this...


Use cells to hold the date boundaries:

• E2 = 9/1/2010
• F2 = 8/31/2011

Book1
	A	B
2	1/9/2002
3	1/28/2008
4	5/20/2011	Yes
5	1/11/2004
6	7/1/2010
7	6/20/2012
8	12/2/2014
9	4/15/2008
10	2/22/2011	Yes
11	6/9/2014
12	3/8/2000
13	10/28/2014
14	3/10/2012
15	6/5/2008
16	9/18/2007
17	8/28/2011	Yes
18	2/3/2005
19	1/4/2014
20	10/24/2004
Sheet1

This formula entered in B2 and copied down:

=IF(AND(A2>=E$2,A2<=F$2),"Yes","")

 

[HC7531]

Thanks very much for your quick response... will give this a try.

CH

 

[blbat]

Here's a way to do it without entering dates in two extra cells-
Formula in Cell B2 and drag down:


=IF(AND($A2>=DATE(2010,9,1),$A2<=DATE(2011,8,31)),"Yes","NO")