If and statements with multiple conditions

[cruzin1957]

Conditions that may occur

A1 = 11/20/2010
A2 = 3/11/2011
A3 = 31 (result needed in number of days)

OR

A1 = 11/20/2010
A2 = 12/20/2010
A3 = 20 (result needed in number of days)

OR

A1 = 11/20/2010
A2 = blank - no date
A3 = 31 (result needed in number of days)

Results needed: I need to complete an if/and statement that will look at both cells A1 and A2 and determine the number of days in December that occurred. I am not having any luck getting this to work. Thanks!

 

[Aladin Akyurek]

Conditions that may occur

A1 = 11/20/2010
A2 = 3/11/2011
A3 = 31 (result needed in number of days)

OR

A1 = 11/20/2010
A2 = 12/20/2010
A3 = 20 (result needed in number of days)

OR

A1 = 11/20/2010
A2 = blank - no date
A3 = 31 (result needed in number of days)

Results needed: I need to complete an if/and statement that will look at both cells A1 and A2 and determine the number of days in December that occurred. I am not having any luck getting this to work. Thanks!

Try something like...

A3:

=IF(COUNT(A1:A2)=2,A2-A1,"")

Format the formula cell as General.

 

[cruzin1957]

Thanks for the reply, but that is not giving me the desired result. I also need to add one more condition:

A1 - 3/1/2011
A2 - Blank
A3 - 0 (results in number of days

Because 3/1/2011 is after December 31, the result should be 0.

 

[Aladin Akyurek]

Thanks for the reply, but that is not giving me the desired result. I also need to add one more condition:

A1 - 3/1/2011
A2 - Blank
A3 - 0 (results in number of days

Because 3/1/2011 is after December 31, the result should be 0.

I see...

Control+shift+enter, not just enter:

=IF(A1,SUM((TEXT(ROW(INDIRECT(A1&":"&IF(A2,A2,TODAY()))),"mmm")="Dec")+0),"")

Does this satisfy? Note that if A2 is empty, today's date is used.

 

[cruzin1957]

This works absolutely awesome . . . except . . . when the date is 2010. For example, if the start date is 1/25/2010 and I am calculating the number of days in March 2011, the answer comes up to 62 days instead of 31. This string is calculating March twice (2010 and 2011).

Thank you so much for your help!

 

[Aladin Akyurek]

This works absolutely awesome . . . except . . . when the date is 2010. For example, if the start date is 1/25/2010 and I am calculating the number of days in March 2011, the answer comes up to 62 days instead of 31. This string is calculating March twice (2010 and 2011).

Thank you so much for your help!

So A1: 1/25/2010 and A2: ?

How does one know what you are calculating with just what are in A1 and A2?