Date & Time :: Duration functions

On this page you will find several functions for calculating datetime durations.

Number of weekdays between two dates

    'Written by Doug Steele MVP
    myInt = DateDiff("d", dte1, dte2) - _
    		DateDiff("ww", dte1, dte2, 1) * 2 - _
    		IIf(Weekday(dte2, 1) = 7, _
    		IIf(Weekday(dte1, 1) = 7, 0, 1), _
    		IIf(Weekday(dte1, 1) = 7, -1, 0))  

Years between two dates

    DateDiff("yyyy",dte1,dte2) + (Format(dte1,"mmddhhnnss") > Format(dte2,"mmddhhnnss"))

Number of months between two dates

    DateDiff("m",dte1,dte2) + (Format(dte1,"ddhhnnss") > Format(dte2,"ddhhnnss"))

Number of days between two dates

    DateDiff("d",dte1,dte2) + (Format(dte1,"hhnnss") > Format(dte2,"hhnnss"))

Number of hours between two dates

    DateDiff("h",dte1,dte2) + (Format(dte1,"nnss") > Format(dte2,"nnss"))

Number of minutes between two dates

    DateDiff("n",dte1,dte2) + (Format(dte1,"ss") > Format(dte2,"ss"))

Number of seconds between two dates

    DateDiff("s",dte1,dte2)