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

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
------------------------------------------------------------------------
sjayar's Profile: http://www.excelforum.com/member.php...o&userid=28435
View this thread: http://www.excelforum.com/showthread...hreadid=481758

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*

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

hi ,
thanks rowan for ur help.
ur suggestion worked


--
sjayar
------------------------------------------------------------------------
sjayar's Profile: http://www.excelforum.com/member.php...o&userid=28435
View this thread: http://www.excelforum.com/showthread...hreadid=481758

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

You're welcome.

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