Pay for Services Java Code

VBA source code from Tushar Kapila - Date Month Difference

  Column C D E F G H I J
Row   I have two dates in excel I want to display the difference in months or days or years      
1   Date 1 Date 2            
2   MM/dd/yyyy     Month Diff (result wanted)        
3   7/15/1999 9/30/2003   50        
4   10/1/2003 3/31/2004   5        
5   4/1/2004 6/30/2006   26        
6   9/1/2006 4/30/2007   7        
8         88        
Formula used in Column F is: =sel2in_cellDateDiff(C7,D7,"m")
sel2in_cellDateDiff is a custom function defined as 
Public Function sel2in_cellDateDiff(s1 As String, s2 As String, period As String) As Date
' function to get the difference of 2 dates in your excel sheet/ workbook
Dim d1 As Date, d2 As Date
d1 = DateValue(s1)
d2 = DateValue(s2)
sel2in_cellDateDiff = DateDiff(period, d1, d2)
End Function

Quick start - download the excel document or the code file mDate.bas {Need to download it, save it in a known folder say c:\mine\ then open excel
in a new workbook

press Alt-F11 to go to the macros

then choose Import and select the saved file.

as shown in this image VBA_Date_Time Help jpeg


Ads by google:

Notice: Undefined index: HTTP_REFERER in /home/t7/public_html/pages/prog/vba/VBA_Date_Time.php on line 458

Notice: Undefined index: HTTP_UA_PIXELS in /home/t7/public_html/pages/prog/vba/VBA_Date_Time.php on line 480

Notice: Undefined index: HTTP_X_UP_DEVCAP_SCREENPIXELS in /home/t7/public_html/pages/prog/vba/VBA_Date_Time.php on line 483

More ads search page that allows you to search within any website uses google works best in Internet explorer and opera freeware minute alarm, easy reminder for back ache - stand up or meeting ...

Help with research - Volunteer computer Cancer cures
Click: , and feed hungry , its free.
Physics-particle research & you helping
Please add these to your start-up how to:      Exercise timer      Blackie      Blog      BaghBan      Savandurga      bone setters      123... a game      Cows and bulls game      images 2002       Kanyakumari and Kovalum  
    New Look       My help pages      Who moved my cheese      My family and me      Programming      EDC meet june 7 2000      forwards , puzzles and info in Bangalore 
    Picnic Dec. 2000      kudremukh trek      cows      Patty pnt       My log      Hognekal & EDC      Poetry 
    all forwards      all forwards      at work      Neat DHTML Needs IE      Meditation technique      MENSA quiz 

Warning: include(): http:// wrapper is disabled in the server configuration by allow_url_include=0 in /home/t7/public_html/pages/prog/vba/VBA_Date_Time.php on line 643

Warning: include( failed to open stream: no suitable wrapper could be found in /home/t7/public_html/pages/prog/vba/VBA_Date_Time.php on line 643

Warning: include(): Failed opening '' for inclusion (include_path='.:/opt/alt/php73/usr/share/pear') in /home/t7/public_html/pages/prog/vba/VBA_Date_Time.php on line 643