If Function Help Needed

**Harry McCurdy** · 07-30-2015, 03:51 PM

using attached workbook, I am trying to figure out how to get the formula in column O to complete the following:

If I2 = "" and cell K2 = "", then O2 = ""
If I2 <> "" and cell K2 = "", then O2 = last day of month of date entered into I2 + end of 2nd month from month of day entered into cell I2.
Example: I2=7/10/15, K2 is blank, O2 should then equal 9/30/15 which is the last day of the 2nd month past the last day of the month of July
else if
I2 <> "" and cell K2 <> "", the O2 = K2 + 365 days.
else if
J2 = 7 regardless if cells I2 or K2 have any dates entered into them, O2 = "Closed"
thanks.

**Ace_XL** · 07-30-2015, 05:00 PM

In O2

=IF(J2=7,"Closed",IF(I2="","",IF(K2="",EOMONTH(I2,2),K2+365)))

Copy down

**natefarm** · 07-30-2015, 05:14 PM

If I2 = "" and cell K2 = "", then O2 = ""

Since this is the first IF that you stated, it appears that this is your top priority, so try this:

Formula:

Please Login or Register  to view this content.

However, you also said

J2 = 7 regardless if cells I2 or K2 have any dates entered into them, O2 = "Closed"

which contradicts the first priority. If that is to be the top priority, then reverse the first two Ifs:

Formula:

Please Login or Register  to view this content.

**natefarm** · 07-30-2015, 05:16 PM

You hadn't mentioned what to do if I2 is blank and K2 is not blank, so I plugged K2 into O2 in that case.

**FDibbins** · 07-30-2015, 05:42 PM

Harry, please stop posting duplicate threads - I haver just closed 3 of them. If you have not has a deply after a day, consider "bumping" the thread to bring it back

**Harry McCurdy** · 07-31-2015, 04:38 AM

Thanks. Works beautifully.

If Function Help Needed

LinkBack

Thread Tools

Rate This Thread

Display

If Function Help Needed

Re: If Function Help Needed

Re: If Function Help Needed

Re: If Function Help Needed

Re: If Function Help Needed

Re: If Function Help Needed

Thread Information

Users Browsing this Thread

Similar Threads

If Then Function Help needed

Help Needed with IF Function

[SOLVED] Function Help Needed

help needed in IF function

[SOLVED] Help needed with sum function

[SOLVED] Function needed please

[SOLVED] Help needed with IF function

[SOLVED] IF function help needed

Bookmarks

Bookmarks

Posting Permissions