to find number of days between 2 dates using vba code in excel

[sjayar]

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

[Rowan Drummond]

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*
>
>

[sjayar]

hi ,
thanks rowan for ur help.
ur suggestion worked

[Rowan Drummond]

You're welcome.

sjayar wrote:
> hi ,
> thanks rowan for ur help.
> ur suggestion worked
>
>