to find number of days between 2 dates using vba code in excel
If you want the number of days between two dates just subtract one from
the other:
Private Sub DTPicker2_Change()
Dim sDate As Date
Dim eDate As Date
sDate = Me.DTPicker1.Value
eDate = Me.DTPicker2.Value
Me.TextBox1 = eDate - sDate
End Sub
Hope this helps
Rowan
sjayar wrote:
Hi All,
i have 2 DateTime Pickers and a textbox.
This texbox should contain the number of days between these 2 dates.
I am unable to calculate number of days between 2 dates.
I have used DateDIf function in the VBA code
when i run the program i get "Compile error: Sub or Function not
defined"
*Please help me to solve this problem.
1. why i get this "Sub or function not defined error"
2. What to do to solve these kind of problem
3. Please help to calculate the number of days between given 2 dates*
|