VBA-Excel: Date-Time Functions – Timer()
Description: The Timer() function returns the Number of seconds and MiliSeconds since 12:00 AM. Format: Timer() Example:
Category: Date Time
VBA-Excel: Date-Time Functions – TimeSerial() and TimeValue()
TimeSerial() Description: The TimeSerial() function returns the Time type based on the parameters provided (Hours, Minutes and Seconds). Format: DateSerial(Hour,Minutes,Seconds) Arguments: Hour Mandatory Type: Numeric or Any Numeric Expression Between 0 and 23
VBA-Excel: Date-Time Functions – WeekDay() and WeekDayName()
WeekDay() Description: The WeekDay function takes Date as a parameter and returns a number between 1 and 7, that is the week day of the date provided. Format: WeekDay (strDate [Firstdayofweek]) Arguments: strDate Mandatory...
VBA-Excel: Date-Time Functions – Month(), Year() and MonthName()
Month() Description: The Month function takes Date as a parameter and returns a number between 1 and 12, that is the month of the date provided. Format: Month(strDate) Arguments: strDate Mandatory Type: Date Date,...
VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
This tutorial will teach you how to get all the working days or weekdays in a specified date range(excluding Satudays and Sundays), simple but very useful when you have come up with a excel...
VBA-Excel: Date-Time Functions – Hour(), Minute(), Second()
Hour() Description: The Hour function takes time as a parameter and returns a number between 0 and 23, that is the Hour of the time provided. Format: Hour(strTime) Arguments: strTime Mandatory Type: Time Time,...
VBA-Excel: Date-Time Functions – FormatDateTime()
Description: The FormatDateTime function takes date as a parameter and returns the specified formatted date or time. Format: FormatDateTime(strDate[,strFormat]) Arguments: strDate Mandatory Type: Date Date which needs to be formatted.
VBA-Excel: Date-Time Functions – Day()
Description: The Day function takes date as a parameter and returns a number between 1 and 31, that is the day of the month. Format: Day(strDate) Arguments: strDate Mandatory Type: Date Date, whose day...
VBA-Excel: Date-Time Functions – DateValue()
Description: The DateValue() function converts string to a date and return it. Format: DateValue(strString) Arguments: strString Mandatory Type: String String that needs to convert into date, if year is not provided then it will...
VBA-Excel: Date-Time Functions – DateSerial()
Description: The DateSerial() function returns the Date type based on the parameters provided (year, month and date). Format: DateSerial(year,month,day) Arguments: Year Mandatory Type: Numeric or Any Numeric Expression Between 100 and 9999, values between...
VBA-Excel: Date-Time Functions – DatePart()
Description: The DatePart() function returns the part of given date based on the parameters provided. Format: DatePart(interval,date[,firstdayofweek[,firstweekofyear]]) Arguments: interval Mandatory Type: String expression The time interval you want as a part of given date
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 Mandatory Type: String expression The time interval you want the difference between two dates.
VBA-Excel: Date-Time Functions – DateAdd()
Description: The DateAdd () function adds the specified time interval to the date and returns a Variant (Date) Format: DateAdd(interval,number,date) Arguments: interval Mandatory Type: String expression The time interval you want to add
VBA-Excel: Date-Time Functions – IsDate()
Description: The IsDate() function determines whether expression can be converted into date and returns the Boolean value based upon that. Format: IsDate(expression) Arguments: expression Mandatory Validate whether expression can be converted into date.
VBA-Excel: Date-Time Functions – CDate()
Description: The CDate() function converts a valid date and time expression to Type Date Format: CDate(date) Arguments: date Mandatory The expression will be converted into Type Date
VBA-Excel: Date-Time Functions – Date(), Now() and Time()
Date() Description: The Date() function returns a Current system date. Format: Date()