I have this formula:

EOMONTH($E$3;E9) returning e.g. 30-06-2011

But if the date it returns is a weekend I want it to return the friday before.

Can anyone help me with this problem?