Danh sách các hàm worksheet và VBA có sẵn trong Microsoft Excel


      Bài viết này sẽ cung cấp cho các bạn Danh sách các hàm worksheet và VBA có sẵn trong Microsoft Excel qua từng phiên bản mà Microsoft đã cung cấp cho người dùng.  Các hàm trong Microsoft Excel thường là một trong 2 loại là worksheet function (WS) và VBA function (VBA), có một số hàm là cả hai loại.

    + Worksheet function (WS): Là một được sử dụng trong các trang tính (Worksheet ), cho phép người dùng nhập như một phần của công thức trong một ô của trang tính.

    + VBA function (VBA): Người dùng có thể sử dụng hàm này trong mã macro được nhập thông qua Microsoft Visual Basic Editor.

    Ngoài các hàm được Microsoft Excel, người dùng có thể tự tạo ra các hàm mới bằng cách code và tận dụng các hàm đã có sẵn bằng ngôn ngữ lập trình Microsoft Visual Basic thông qua Microsoft Visual Basic Editor.  Bạn có thể bật chế độ Developer và vào Microsoft Visual Basic Editor ở bài viết tại đây.

Formula And Functino In Excel


Danh sách các hàm worksheet và VBA có sẵn trong Microsoft Excel theo thứ từ Anphabet.

Tên Ý nghĩa hàm Loại hàm Phiên bản Excel hỗ trợ
ABS (WS, VBA) Returns the absolute value of a number WS, VBA  
ACCRINT (WS) Returns the accrued interest for a security that pays interest on a periodic basis WS  
ACCRINTM (WS) Returns the accrued interest for a security that pays interest at maturity WS  
ACOS (WS) Returns the arccosine (in radians) of a number WS  
ACOSH (WS) Returns the inverse hyperbolic cosine of a number WS  
ADDRESS (WS) Returns a text representation of a cell address WS  
AGGREGATE (WS) Apply functions such AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows WS  
AMORDEGRC (WS) Returns the linear depreciation of an asset for each accounting period, on a prorated basis WS  
AMORLINC (WS) Returns the depreciation of an asset for each accounting period, on a prorated basis WS  
AND (WS) Returns TRUE if all conditions are TRUE WS  
AND (VBA) Returns TRUE if all conditions are TRUE VBA  
AREAS (WS) Returns the number of ranges in a reference WS  
ASC (VBA) Returns ASCII value of a character VBA  
ASIN (WS) Returns the arcsine (in radians) of a number WS  
ASINH (WS) Returns the inverse hyperbolic sine of a number WS  
ATAN (WS) Returns the arctangent (in radians) of a number WS  
ATAN2 (WS) Returns the arctangent (in radians) of (x,y) coordinates WS  
ATANH (WS) Returns the inverse hyperbolic tangent of a number WS  
ATN (VBA) Returns the arctangent of a number VBA  
AVEDEV (WS) Returns the average of the absolute deviations of the numbers provided WS  
AVERAGE (WS) Returns the average of the numbers provided WS  
AVERAGEA (WS) Returns the average of the numbers provided and treats TRUE as 1 and FALSE as 0 WS  
AVERAGEIF (WS) Returns the average of all numbers in a range of cells, based on a given criteria WS  
AVERAGEIFS (WS) Returns the average of all numbers in a range of cells, based on multiple criteria WS  
BAHTTEXT (WS) Returns the number in Thai text WS  
BETA.DIST (WS) Returns the beta distribution WS  
BETA.INV (WS) Returns the inverse of the cumulative beta probability density function WS  
BETADIST (WS) Returns the cumulative beta probability density function WS  
BETAINV (WS) Returns the inverse of the cumulative beta probability density function WS  
BIN2DEC (WS) Converts a binary number to a decimal number WS  
BIN2HEX (WS) Converts a binary number to a hexadecimal number WS  
BIN2OCT (WS) Converts a binary number to an octal number WS  
BINOM.DIST (WS) Returns the individual term binomial distribution probability WS  
BINOM.INV (WS) Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion WS  
BINOMDIST (WS) Returns the individual term binomial distribution probability WS  
CASE (VBA) Has the functionality of an IF-THEN-ELSE statement VBA  
CBOOL (VBA) Converts a value to a boolean VBA  
CBYTE (VBA) Converts a value to a byte (ie: number between 0 and 255) VBA  
CCUR (VBA) Converts a value to currency VBA  
CDATE (VBA) Converts a value to a date VBA  
CDBL (VBA) Converts a value to a double VBA  
CDEC (VBA) Converts a value to a decimal number VBA  
CEILING (WS) Returns a number rounded up based on a multiple of significance WS  
CEILING.PRECISE (WS) Returns a number rounded up to the nearest integer or to the nearest multiple of significance WS  
CELL (WS) Used to retrieve information about a cell such as contents, formatting, size, etc. WS  
CHAR (WS) Returns the character based on the ASCII value WS  
CHDIR (VBA) Used to change the current directory or folder VBA  
CHDRIVE (VBA) Used to change the current drive VBA  
CHIDIST (WS) Returns the one-tailed probability of the chi-squared distribution WS  
CHIINV (WS) Returns the inverse of the one-tailed probability of the chi-squared distribution WS  
CHITEST (WS) Returns the value from the chi-squared distribution WS  
CHOOSE (WS, VBA) Returns a value from a list of values based on a given position WS, VBA  
CHR (VBA) Returns the character based on the ASCII value VBA  
CINT (VBA) Converts a value to an integer VBA  
CLEAN (WS) Removes all nonprintable characters from a string WS  
CLNG (VBA) Converts a value to a long integer VBA  
CODE (WS) Returns the ASCII value of a character or the first character in a cell WS  
COLUMN (WS) Returns the column number of a cell reference WS  
COLUMNS (WS) Returns the number of columns in a cell reference WS  
COMBIN (WS) Returns the number of combinations for a specified number of items WS  
COMBINA (WS) Returns the number of combinations for a specified number of items and includes repetitions WS  
COMPLEX (WS) Converts coefficients (real and imaginary) into a complex number WS  
CONCAT (WS) Used to join 2 or more strings together WS  
CONCATENATE (WS) Used to join 2 or more strings together (replaced by CONCAT Function) WS  
CONCATENATE with & (WS, VBA) Used to join 2 or more strings together using the & operator WS, VBA  
CONVERT (WS) Convert a number from one measurement unit to another measurement unit WS  
COS (WS, VBA) Returns the cosine of an angle WS, VBA  
COSH (WS) Returns the hyperbolic cosine of a number WS  
COUNT (WS) Counts the number of cells that contain numbers as well as the number of arguments that contain numbers WS  
COUNTA (WS) Counts the number of cells that are not empty as well as the number of value arguments provided WS  
COUNTBLANK (WS) Counts the number of empty cells in a range WS  
COUNTIF (WS) Counts the number of cells in a range, that meets a given criteria WS  
COUNTIFS (WS) Counts the number of cells in a range, that meets a single or multiple criteria WS  
COVAR (WS) Returns the covariance, the average of the products of deviations for two data sets WS  
CSNG (VBA) Converts a value to a single-precision number VBA  
CSTR (VBA) Converts a value to a string VBA  
CURDIR (VBA) Returns the current path VBA  
CVAR (VBA) Converts a value to a variant VBA  
DATE (WS) Returns the serial date value for a date WS  
DATE (VBA) Returns the current system date VBA  
DATEADD (VBA) Returns a date after which a certain time/date interval has been added VBA  
DATEDIF (WS) Returns the difference between two date values, based on the interval specified WS  
DATEDIFF (VBA) Returns the difference between two date values, based on the interval specified VBA  
DATEPART (VBA) Returns a specified part of a given date VBA  
DATESERIAL (VBA) Returns a date given a year, month, and day value VBA  
DATEVALUE (WS, VBA) Returns the serial number of a date WS, VBA  
DAVERAGE (WS) Averages all numbers in a column in a list or database, based on a given criteria WS  
DAY (WS, VBA) Returns the day of the month (a number from 1 to 31) given a date value WS, VBA  
DAYS (WS) Returns the number of days between 2 dates WS  
DAYS360 (WS) Returns the number of days between two dates based on a 360-day year WS  
DB (WS) Returns the depreciation of an asset based on the fixed-declining balance method WS  
DCOUNT (WS) Returns the number of cells in a column or database that contains numeric values and meets a given criteria WS  
DCOUNTA (WS) Returns the number of cells in a column or database that contains nonblank values and meets a given criteria WS  
DDB (WS, VBA) Returns the depreciation of an asset based on the double-declining balance method WS, VBA  
DEGREES (WS) Converts radians into degrees WS  
DGET (WS) Retrieves from a database a single record that matches a given criteria WS  
DIR (VBA) Returns the first filename that matches the pathname and attributes specified VBA  
DMAX (WS) Returns the largest number in a column in a list or database, based on a given criteria WS  
DMIN (WS) Returns the smallest number in a column in a list or database, based on a given criteria WS  
DOLLAR (WS) Converts a number to text, using a currency format WS  
DPRODUCT (WS) Returns the product of the numbers in a column in a list or database, based on a given criteria WS  
DSTDEV (WS) Returns the standard deviation of a population based on a sample of numbers WS  
DSTDEVP (WS) Returns the standard deviation of a population based on the entire population of numbers WS  
DSUM (WS) Sums the numbers in a column or database that meets a given criteria WS  
DVAR (WS) Returns the variance of a population based on a sample of numbers WS  
DVARP (WS) Returns the variance of a population based on the entire population of numbers WS  
EDATE (WS) Adds a specified number of months to a date and returns the result as a serial date WS  
ENVIRON (VBA) Returns the value of an operating system environment variable VBA  
EOMONTH (WS) Calculates the last day of the month after adding a specified number of months to a date WS  
ERROR.TYPE (WS) Returns the numeric representation of an Excel error WS  
EVEN (WS) Rounds a number up to the nearest even integer WS  
EXACT (WS) Compares two strings and returns TRUE if both values are the same WS  
EXP (WS, VBA) Returns e raised to the nth power WS, VBA  
FACT (WS) Returns the factorial of a number WS  
FALSE (WS) Returns a logical value of FALSE WS  
FILEDATETIME (VBA) Returns the date and time of when a file was created or last modified VBA  
FILELEN (VBA) Returns the size of a file in bytes VBA  
FIND (WS) Returns the location of a substring in a string (case-sensitive) WS  
FIX (VBA) Returns the integer portion of a number VBA  
FIXED (WS) Returns a text representation of a number rounded to a specified number of decimal places WS  
FLOOR (WS) Returns a number rounded down based on a multiple of significance WS  
FOR…NEXT (VBA) Used to create a FOR LOOP VBA  
FORECAST (WS) Returns a prediction of a future value based on existing values provided WS  
FORMAT DATES (VBA) Takes a date expression and returns it as a formatted string VBA  
FORMAT NUMBERS (VBA) Takes a numeric expression and returns it as a formatted string VBA  
FORMAT STRINGS (VBA) Takes a string expression and returns it as a formatted string VBA  
FREQUENCY (WS) Returns how often values occur within a set of data. It returns a vertical array of numbers WS  
FV (WS, VBA) Returns the future value of an investment WS, VBA  
GETATTR (VBA) Returns an integer that represents the attributes of a file, folder, or directory VBA  
GROWTH (WS) Returns the predicted exponential growth based on existing values provided WS  
HLOOKUP (WS) Performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index_number WS  
HOUR (WS, VBA) Returns the hours (a number from 0 to 23) from a time value WS, VBA  
HYPERLINK (WS) Creates a shortcut to a file or Internet address WS  
IF (WS) Returns one value if the condition is TRUE or another value if the condition is FALSE WS  
IF (more than 7) (WS) Nest more than 7 IF functions more than  
IF (up to 7) (WS) Nest up to 7 IF functions up to 7  
IF-THEN-ELSE (VBA) Returns a value if a specified condition evaluates to TRUE or another value if it evaluates to FALSE VBA  
IFERROR (WS) Used to return an alternate value if a formula results in an error WS  
IFNA (WS) Used to return an alternate value if a formula results in #N/A error WS  
IFS (WS) Specify multiple IF conditions within 1 function WS  
INDEX (WS) Returns either the value or the reference to a value from a table or range WS  
INDIRECT (WS) Returns the reference to a cell based on its string representation WS  
INFO (WS) Returns information about the operating environment WS  
INSTR (VBA) Returns the position of the first occurrence of a substring in a string VBA  
INSTRREV (VBA) Returns the position of the first occurrence of a string in another string, starting from the end of the string VBA  
INT (WS, VBA) Returns the integer portion of a number WS, VBA  
INTERCEPT (WS) Returns the y-axis intersection point of a line using x-axis values and y-axis values WS  
IPMT (WS, VBA) Returns the interest payment for an investment WS, VBA  
IRR (WS, VBA) Returns the internal rate of return for a series of cash flows WS, VBA  
ISBLANK (WS) Used to check for blank or null values WS  
ISDATE (VBA) Returns TRUE if the expression is a valid date VBA  
ISEMPTY (VBA) Used to check for blank cells or uninitialized variables VBA  
ISERR (WS) Used to check for error values except #N/A WS  
ISERROR (WS, VBA) Used to check for error values WS, VBA  
ISLOGICAL (WS) Used to check for a logical value (TRUE or FALSE) WS  
ISNA (WS) Used to check for #N/A error WS  
ISNONTEXT (WS) Used to check for a value that is not text WS  
ISNULL (VBA) Used to check for a NULL value VBA  
ISNUMBER (WS) Used to check for a numeric value WS  
ISNUMERIC (VBA) Used to check for a numeric value VBA  
ISOWEEKNUM (WS) Returns the ISO week number for a date WS  
ISPMT (WS) Returns the interest payment for an investment WS  
ISREF (WS) Used to check for a reference WS  
ISTEXT (WS) Used to check for a text value WS  
LARGE (WS) Returns the nth largest value from a set of values WS  
LCASE (VBA) Converts a string to lowercase VBA  
LEFT (WS, VBA) Extract a substring from a string, starting from the left-most character WS, VBA  
LEN (WS, VBA) Returns the length of the specified string WS, VBA  
LINEST (WS) Uses the least squares method to calculate the statistics for a straight line and returns an array describing that line WS  
LN (WS) Returns the natural logarithm of a number WS  
LOG (WS) Returns the logarithm of a number to a specified base WS  
LOG (VBA) Returns the natural logarithm of a number VBA  
LOG10 (WS) Returns the base-10 logarithm of a number WS  
LOOKUP (WS) Returns a value from a range (one row or one column) or from an array WS  
LOWER (WS) Converts all letters in the specified string to lowercase WS  
LTRIM (VBA) Removes leading spaces from a string VBA  
MATCH (WS) Searches for a value in an array and returns the relative position of that item WS  
MAX (WS) Returns the largest value from the numbers provided WS  
MAXA (WS) Returns the largest value from the values provided (numbers, text and logical values) WS  
MAXIFS (WS) Returns the largest value in a range, that meets a single or multiple criteria WS  
MDETERM (WS) Returns the matrix determinant of an array WS  
MEDIAN (WS) Returns the median of the numbers provided WS  
MID (WS, VBA) Extracts a substring from a string (starting at any position) WS, VBA  
MIN (WS) Returns the smallest value from the numbers provided WS  
MINA (WS) Returns the smallest value from the values provided (numbers, text and logical values) WS  
MINIFS (WS) Returns the smallest value in a range, that meets a single or multiple criteria WS  
MINUTE (WS, VBA) Returns the minutes (a number from 0 to 59) from a time value WS, VBA  
MINVERSE (WS) Returns the inverse matrix for a given matrix WS  
MIRR (WS, VBA) Returns the modified internal rate of return for a series of cash flows WS, VBA  
MKDIR (VBA) Used to create a new folder or directory VBA  
MMULT (WS) Returns the matrix product of two arrays WS  
MOD (WS) Returns the remainder after a number is divided by a divisor WS  
MODE (WS) Returns most frequently occurring number WS  
MODE.MULT (WS) Returns a vertical array of the most frequently occurring numbers WS  
MODE.SNGL (WS) Returns most frequently occurring number WS  
MONTH (WS, VBA) Returns the month (a number from 1 to 12) given a date value WS, VBA  
MONTHNAME (VBA) Returns a string representing the month given a number from 1 to 12 VBA  
N (WS) Converts a value to a number WS  
NA (WS) Returns the #N/A error value WS  
NETWORKDAYS (WS) Returns the number of work days between 2 dates, excluding weekends and holidays WS  
NETWORKDAYS.INTL (WS) Returns the number of work days between 2 dates, excluding weekends and holidays WS  
NOT (WS) Returns the reversed logical value WS  
NOW (WS, VBA) Returns the current system date and time WS, VBA  
NPER (WS, VBA) Returns the number of periods for an investment WS, VBA  
NPV (WS, VBA) Returns the net present value of an investment WS, VBA  
NUMBERVALUE (WS) Returns a text to a number specifying the decimal and group separators WS  
ODD (WS) Rounds a number up to the nearest odd integer WS  
OFFSET (WS) Returns a reference to a range that is offset a number of rows and columns WS  
OR (WS) Returns TRUE if any of the conditions are TRUE WS  
OR (VBA) Returns TRUE if any of the conditions are TRUE VBA  
PERCENTILE (WS) Returns the nth percentile from a set of values WS  
PERCENTRANK (WS) Returns the nth percentile from a set of values WS  
PERMUT (WS) Returns the number of permutations for a specified number of items WS  
PI (WS) Returns the mathematical constant called pi WS  
PMT (WS, VBA) Returns the payment amount for a loan WS, VBA  
POWER (WS) Returns the result of a number raised to a given power WS  
PPMT (WS, VBA) Returns the payment on the principal for a particular payment WS, VBA  
PRODUCT (WS) Multiplies the numbers and returns the product WS  
PROPER (WS) Sets the first character in each word to uppercase and the rest to lowercase WS  
PV (WS, VBA) Returns the present value of an investment WS, VBA  
QUARTILE (WS) Returns the quartile from a set of values WS  
RADIANS (WS) Converts degrees into radians WS  
RAND (WS) Returns a random number that is greater than or equal to 0 and less than 1 WS  
RANDBETWEEN (WS) Returns a random number that is between a bottom and top range WS  
RANDOMIZE (VBA) Used to change the seed value used by the random number generator for the RND function VBA  
RANK (WS) Returns the rank of a number within a set of numbers WS  
RATE (WS, VBA) Returns the interest rate for an annuity WS, VBA  
REPLACE (WS) Replaces a sequence of characters in a string with another set of characters WS  
REPLACE (VBA) Replaces a sequence of characters in a string with another set of characters VBA  
REPT (WS) Returns a repeated text value a specified number of times WS  
RIGHT (WS, VBA) Extracts a substring from a string starting from the right-most character WS, VBA  
RND (VBA) Used to generate a random number (integer value) VBA  
ROMAN (WS) Converts a number to roman numeral WS  
ROUND (WS) Returns a number rounded to a specified number of digits WS  
ROUND (VBA) Returns a number rounded to a specified number of digits VBA  
ROUNDDOWN (WS) Returns a number rounded down to a specified number of digits WS  
ROUNDUP (WS) Returns a number rounded up to a specified number of digits WS  
ROW (WS) Returns the row number of a cell reference WS  
ROWS (WS) Returns the number of rows in a cell reference WS  
RTRIM (VBA) Removes trailing spaces from a string VBA  
SEARCH (WS) Returns the location of a substring in a string WS  
SECOND (WS) Returns the seconds (a number from 0 to 59) from a time value WS  
SETATTR (VBA) Used to set the attributes of a file VBA  
SGN (VBA) Returns the sign of a number VBA  
SIGN (WS) Returns the sign of a number WS  
SIN (WS, VBA) Returns the sine of an angle WS, VBA  
SINH (WS) Returns the hyperbolic sine of a number WS  
SLN (WS, VBA) Returns the depreciation of an asset based on the straight-line depreciation method WS, VBA  
SLOPE (WS) Returns the slope of a regression line based on the data points identified by known_y_values and known_x_values WS  
SMALL (WS) Returns the nth smallest value from a set of values WS  
SPACE (VBA) Returns a string with a specified number of spaces VBA  
SPLIT (VBA) Used to split a string into substrings based on a delimiter VBA  
SQR (VBA) Returns the square root of a number VBA  
SQRT (WS) Returns the square root of a number WS  
STDEV (WS) Returns the standard deviation of a population based on a sample of numbers WS  
STDEVA (WS) Returns the standard deviation of a population based on a sample of numbers, text, and logical values WS  
STDEVP (WS) Returns the standard deviation of a population based on an entire population of numbers WS  
STDEVPA (WS) Returns the standard deviation of a population based on an entire population of numbers, text, and logical values WS  
STR (VBA) Returns a string representation of a number VBA  
STRCOMP (VBA) Returns an integer value representing the result of a string comparison VBA  
STRCONV (VBA) Returns a string converted to uppercase, lowercase, proper case or Unicode VBA  
STRREVERSE (VBA) Returns a string whose characters are in reverse order VBA  
SUBSTITUTE (WS) Replaces a set of characters with another WS  
SUBTOTAL (WS) Returns the subtotal of the numbers in a column in a list or database WS  
SUM (WS) Adds all numbers in a range of cells WS  
SUMIF (WS) Adds all numbers in a range of cells based on one criteria WS  
SUMIFS (WS) Adds all numbers in a range of cells, based on a single or multiple criteria WS  
SUMPRODUCT (WS) Multiplies the corresponding items in the arrays and returns the sum of the results WS  
SUMSQ (WS) Returns the sum of the squares of a series of values WS  
SUMX2MY2 (WS) Returns the sum of the difference of squares between two arrays WS  
SUMX2PY2 (WS) Returns the sum of the squares of corresponding items in the arrays WS  
SUMXMY2 (WS) Returns the sum of the squares of the differences between corresponding items in the arrays WS  
SWITCH (WS) Compares an expression to a list of values and returns the corresponding result WS  
SWITCH (VBA) Evaluates a list of expressions and returns the corresponding value for the first expression in the list that is TRUE VBA  
SYD (WS, VBA) Returns the depreciation of an asset based on the sum-of-years’ digits depreciation method WS, VBA  
T (WS) Returns the text referred to by a value WS  
TAN (WS, VBA) Returns the tangent of an angle WS, VBA  
TANH (WS) Returns the hyperbolic tangent of a number WS  
TEXT (WS) Returns a value converted to text with a specified format WS  
TEXTJOIN (WS) Used to join 2 or more strings together separated by a delimiter WS  
TIME (WS) Returns a decimal number given an hour, minute and second value WS  
TIMESERIAL (VBA) Returns a time given an hour, minute, and second value VBA  
TIMEVALUE (WS, VBA) Returns the serial number of a time WS, VBA  
TODAY (WS) Returns the current system date WS  
TRANSPOSE (WS) Returns a transposed range of cells WS  
TRIM (WS, VBA) Returns a text value with the leading and trailing spaces removed WS, VBA  
TRUE (WS) Returns a logical value of TRUE WS  
TRUNC (WS) Returns a number truncated to a specified number of digits WS  
TYPE (WS) Returns the type of a value WS  
UCASE (VBA) Converts a string to all uppercase VBA  
UNICHAR (WS) Returns the Unicode character based on the Unicode number provided WS  
UNICODE (WS) Returns the Unicode number of a character or the first character in a string WS  
UPPER (WS) Convert text to all uppercase WS  
VAL (VBA) Returns the numbers found in a string VBA  
VALUE (WS) Converts a text value that represents a number to a number WS  
VAR (WS) Returns the variance of a population based on a sample of numbers WS  
VARA (WS) Returns the variance of a population based on a sample of numbers, text, and logical values WS  
VARP (WS) Returns the variance of a population based on an entire population of numbers WS  
VARPA (WS) Returns the variance of a population based on an entire population of numbers, text, and logical values WS  
VDB (WS) Returns the depreciation of an asset based on a variable declining balance depreciation method WS  
VLOOKUP (WS) Performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position WS  
WEEKDAY (WS, VBA) Returns a number representing the day of the week, given a date value WS, VBA  
WEEKDAYNAME (VBA) Returns a string representing the day of the week given a number from 1 to 7 VBA  
WEEKNUM (WS) Returns the week number for a date WS  
WHILE…WEND (VBA) Used to create a WHILE LOOP VBA  
WORKDAY (WS) Adds a specified number of work days to a date and returns the result as a serial date WS  
WORKDAY.INTL (WS) Adds a specified number of work days to a date and returns the result as a serial date (customizable weekends) WS  
XIRR (WS) Returns the internal rate of return for a series of cash flows that may not be periodic WS  
YEAR (WS, VBA) Returns a four-digit year (a number from 1900 to 9999) given a date value WS, VBA  
YEARFRAC (WS) Returns the number of days between 2 dates as a year fraction WS

 


Phản hồi

Phản hồi