VBA Code to Calculate the Difference Between Two Dates in Excel

VBA Code:

' VBA Code to Calculate the Difference Between Two Dates in Excel
' This code calculates the difference between two dates in days

Sub CalculateDateDifference()
    Dim date1 As Date
    Dim date2 As Date
    Dim diff As Long
    
    ' Set the values of the two dates
    date1 = #1/1/2022#
    date2 = #1/31/2022#
    
    ' Calculate the difference between the two dates
    diff = DateDiff("d", date1, date2)
    
    ' Display the result in a message box
    MsgBox "The difference between the two dates is " & diff & " days."
End Sub


Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment