View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alfredo_CPA Alfredo_CPA is offline
external usenet poster
 
Posts: 45
Default Last Friday of the month

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