How To Calculate Date Intervals With VBA DateAdd

One of my clients ask me to design a little utility to operate like the Outlook appointment
recurrence feature.

This the first basic step, so I wanted to share how I did it.

I have a basic form where I’ll probably be adding more variables, but the functionality basically works like this:

I have an input box for the start date, and how many times the occurrence should happen, and then at what frequency (monthly, quarterly, yearly, or semiannually)

How_To_Calculate_Date_Intervals_With_VBA_DateAdd


Click here to download the sample database: “How To Calculate Date Intervals With VBA DateAdd”

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags:




 

Call Erik Now