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

--


Regards,


Peo Sjoblom

"Alfredo_CPA" .(donotspam) wrote in message
...
I have in cell "A5" the last day of the month (i.e. las month was 08-31-08
and this month will be 09-30-08)
I need a formula in "A6" (that works for every month) that gives me the
last
friday of that specific month based on the input on "A5"

Thanks
--
I'm not a looser, I keep trying.