=DATE(YEAR(A1),MONTH(A1)+2,1)+1-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+2,1)+2)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Hans" wrote in message
...
IF function is true, need to change date from another cell,eg 28-07-06, to
last friday of the next month,eg,25-08-06