VBA-Excel: Date-Time Functions – DateDiff()

Description:

The DateDiff() function returns the specified time interval difference between the two dates provided.

Format:

DateDiff(interval,date1,date2[,firstdayofweek[,firstweekofyear]])

Arguments:
  • interval
    • Manda­tory
    • Type: String expression
    • The time interval you want the difference between two dates.

Read more

VBA-Excel: Array Functions – LBound and UBound()

Description:

 LBound and UBound() Functions returns the starting index ( Lower Bound) and Ending index (Upper Bound) of an array.

Format:

LBound(arrArrayName [, dimension])

UBound(arrArrayName [, dimension])

 

Arguments:
  • arrArrayName
    • Manda­tory
    • Type: Array
    • Array whose lower or upper bound needs to found

    Read more

VBA-Excel: Array Functions – Split()

Description:

 Split() Function returns one dimensional array containing the substrings, after splitting the main string based upon the delimiter provided.

Format:

Split(strMainString [, delimiter[,intlimit[, vbCompare]]])

Arguments:

  • str­Main­String
    • Manda­tory
    • Type: String
    • String which will be split

    Read more