Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
#2
![]() |
|||
|
|||
![]()
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* |
#3
![]() |
|||
|
|||
![]() 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 |
#4
![]() |
|||
|
|||
![]()
You're welcome.
sjayar wrote: hi , thanks rowan for ur help. ur suggestion worked |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I get Excel to find the first number in a list greater tha | Excel Worksheet Functions | |||
Number of years, months, days between two dates. | Excel Worksheet Functions | |||
Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Using the Find tool in EXCEL | Excel Worksheet Functions |