Thread: set month end
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chilliputt
 
Posts: n/a
Default set month end

Hi. I need a function to customize month end to the last Friday of each
month. So for December 2005, the start date would be (A1) 11-26-05, and the
end date would be (A2) 12-30-05. I want to autofill the dates that fall
within this range down starting in A3.

Any thoughts?