View Single Post
  #2   Report Post  
Rowan Drummond
 
Posts: n/a
Default 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*