It does the job perfectly

Thanks a lot!!

"Mike H" wrote:

Try

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

With a date in a1

Mike

"Alfredo_CPA" wrote:

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€¦