ExcelBanter - help with if statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help with if statement (https://www.excelbanter.com/excel-worksheet-functions/209476-help-if-statement.html)

Yossy

help with if statement

If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should
look at date (Cell A10 and compare with cell B10) cell A10 must be with the
B10 date.

A10 = 10/17/2008

B10 = (10/1/2008 - 10/31/2008)

All help totally appreciated. Thanks

Mike H

help with if statement

Hi,

Are you saying you have 2 dates in B10 and you want to check that a10 is
between these dates?

If you do have 2 dates in B10 how are they arrived at because if you do have
2 dates in the cell and you have typed them then a comparison is a lot more
complicated than it need be.

Mike

"Yossy" wrote:

If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should
look at date (Cell A10 and compare with cell B10) cell A10 must be with the
B10 date.

A10 = 10/17/2008

B10 = (10/1/2008 - 10/31/2008)

All help totally appreciated. Thanks

Glenn

help with if statement

Yossy wrote:
If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should
look at date (Cell A10 and compare with cell B10) cell A10 must be with the
B10 date.

A10 = 10/17/2008

B10 = (10/1/2008 - 10/31/2008)

All help totally appreciated. Thanks

=IF(AND(A5C5,A10=DATEVALUE(MID(B10,2,FIND("-",B10)-3)),A10<=DATEVALUE(SUBSTITUTE(MID(B10,FIND("-",B10)+2,12),")",""))),"YES","NO")

ShaneDevenshire

help with if statement

Hi,

The key to solving this problem is to know what you actually have in B10:

(10/1/2008 - 10/31/2008)
or
10/1/2008 - 10/31/2008

Before we get carries away, I notice that this represents October. You can
make your task easier if you enter October or Oct in cell B10 if you are
trying to indicate a whole month. Or better yet enter 10/1/2008 and format
it to show Oct-2008.

In this last case the formula would be

=if(AND(A5C5,MONTH(A10)=MONTH(B10)),"Yes","No")

--
Thanks,
Shane Devenshire

"Yossy" wrote:

If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should
look at date (Cell A10 and compare with cell B10) cell A10 must be with the
B10 date.

A10 = 10/17/2008

B10 = (10/1/2008 - 10/31/2008)

All help totally appreciated. Thanks

All times are GMT +1. The time now is 12:54 PM.