Simplify an excel formula

[kitty_el]

Hi, I am wondering if anyone can help me simplify an excel formula. The formula works fine but it’s quite long. I can’t think of another way to write it. The formula is:

=IF((EOMONTH(I3,0)-MOD(WEEKDAY(EOMONTH(I3,0))+1,7)-4)<4=EOMONTH(I3,0),EOMONTH(I3,0)-MOD(WEEKDAY(EOMONTH(I3,0))+1,7)-4,EOMONTH(I3,0)-WEEKDAY(EOMONTH(I3,0)-2))

The formula is working out which Monday is the best to return (last or 2nd to last) depending on how close it is to the last Friday of the month

Hope this makes sense

 

[Fluff]

That formula does not work. The 1st part (EOMONTH(I3,0)-MOD(WEEKDAY(EOMONTH(I3,0))+1,7)-4)<4=EOMONTH(I3,0) will always return FALSE so this part EOMONTH(I3,0)-MOD(WEEKDAY(EOMONTH(I3,0))+1,7)-4 will never be calculated.

Also the last Monday will always be closest to the Friday, so do you just want the last Monday?
If so just use

=WORKDAY.INTL(EOMONTH(I3,0)+1,-1,"0111111")

 

[Fluff]

Having had another look at your formula, I think that all you need is

=EOMONTH(I3,0)-MOD(WEEKDAY(EOMONTH(I3,0))+1,7)-4

 

[Tetra201]

Or a shorter one:

=EOMONTH(I3,0)-WEEKDAY(EOMONTH(I3,0)+1,16)-3