Thread: VBA to populate workdat between dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel,microsoft.public.excel.programming
fLiPMoD£ fLiPMoD£ is offline
external usenet poster
  
Posts: 14
Default VBA to populate workdat between dates
Hello,

I am hoping someone can help me. The problem is I am trying to get a VBA
code that will request the user to input two dates and will populate the
workdays between these dates into a specified column

User Inputs

StartDate = 01-Mar-2006
EndDate = 01-Mar-2007

Output in say column C
01-Mar-2006
02-Mar-2006
03-Mar-2006
06-Mar-2006
07-Mar-2006
08-Mar-2006
09-Mar-2006
10-Mar-2006
13-Mar-2006
14-Mar-2006
15-Mar-2006

etc

Thanks in Advance


Reply With QuoteReply With Quote