Hi All,

OK, here is my problem:
My bank cycles start on the 2nd Wednesday of each month. So, I created a calendar in Excel where I identify the cycle Start Dates. The formula looks like this:
=IF(AND(E100>7,E100<15,G100=3),"START",0)
In Column E are days of month, from 1 through 31
I figure the 2nd Wednesday of the month has to start no earlier than the 8th day (hence >7) and has to end no later than the 14th day (hence <15).

In Column G, I have weekdays, 1 though 7.

So, now the column with that formula either gives me “START” or 0.

Where I need help is the next step:

I want the formula to tell me if this is the cycle END, which is just one day prior, or 2nd Tuesday of the month. I tried to play with NESTED IF but it got confusing.
Any help is appreciated. Thanks!