Category: Date Time

0

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...

0

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 Manda­tory Type: Numeric or Any Numeric Expression Between 100 and 9999, values between...

0

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 Manda­tory Type: String expression The time interval you want as a part of given date

1

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.

10

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 Manda­tory Type: String expression The time interval you want to add

0

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.

Show Buttons
Hide Buttons
%d bloggers like this: