Thread: Find last weekday of the month with vba for all months
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Find last weekday of the month with vba for all months
On Sun, 23 Sep 2012 17:43:29 -0700 (PDT), Cimjet wrote:

Thank you Ron
Just could not get my head around it.
Much appreciated.
John

Glad to help.
But please note that if you will be using this in versions of Excel prior to 2007, a different algorithm will be required, as the Workday was part of the Analysis ToolPak (and not a built-in worksheetfunction) prior to Excel 2007.
Post back if that might be an issue.
Reply With QuoteReply With Quote