Manipulating Dates and Times

This section provides solutions to five common date manipulation issues:

• Finding the number of days in a specified month
  
  
• Counting the number of iterations of a specific weekday in a month
  
  
• Determining whether a specified year is a leap year
  
  
• Rounding time to a specified increment
  
  
• Converting numbers or strings to dates, given an input format specification

In each case, we’ve provided a VBA function or two, as well as some examples showing the usage of the function, to help get you started.

© 1997 by SYBEX Inc. All rights reserved.