Hi All-
Does anyone know of a way to get/calculate ALL of the days of the months from a date range entered into an inputbox in which a user may enter any day of a month? In other words, the user enters 9/14/2009 in the first inputbox then 10/8/2012 in the second and code would calculate the number of days as 9/1/2009 - 10/31/2012.
Here is the current code I'm using that calculates only the exact days:
[/SIZE]![]()
Dim DBstarts As Date Dim DBends As Date DBstarts = InputBox("Enter the Date that DB begins:") DBends = InputBox("Enter the Date in which DB ends:") daysofDB = -(DBstarts - DBends) MsgBox daysofDB
Bookmarks