Description:
The Timer() function returns the Number of seconds and MiliSeconds since 12:00 AM.
Format:
Timer()
Example:
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
- Type: Date
- Date, whose Week Date need to be calculated.
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, whose Month need to be calculated.
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 where you have to work with all the business working days. Example: If the date range is mentioned between 8-Jan-2014 to … Read more
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, whose hours need to be calculated.
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 needs to be calculated.
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 take the current year by default.
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 0-99 will be considered as 1900-1999
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