Log in
x
or
x
x
Register
x

or

Excel Functions Guide | ExtendOffice

Date and Time
DATE Create date with year, month and day year month day
DATEIF Return the years, months or days between two dates start_date end_date unit
DATEVALUE Convert a date stored as text format to a valid date date_text
DAY Get the day as a number (1 to 31) from a date date
DAYS Get the number of days between two dates start_date end_date
DAYS360 Get the number of days between 2 dates in a 360-day year start_date end_date method
EDATE Add n months for a date start_date months
EOMONTH Get the last day of month n months in future or past start_date months
ISOWEEKNUM Get ISO week number from a given date date
HOUR Get the hour as a number (0 to 23) from a date time Serial_number
MINUTE Return the minute as number (0 to 59) from time serial_number
MONTH Get the month as integer number (1 to 12) from date serial_number
NETWORKDAYS Get the number of working days between two dates Start_date End_date Holidays
NETWORKDAYS.INTL Get workdays between two dates Start_date End_date Weekend Holidays
NOW Get the current date and time  
SECOND Return the seconds as number (0 to 59) from time serial_number
TIME Create time with hours, minutes and seconds Hour Minute Second
TIMEVALUE Get time from a text string time_text
TODAY Get the current date  
WEEKDAY Get day of the week as a number (1 to 7) from date Serial_number Return_type
Lookup and Reference
ADDRESS Return the cell address reference by column number and row number. Row_num Column_num Abs_num A1 Sheet_text
AREAS Return the number of areas that make up the reference Reference
CHOOSE Return a value from the list of value argument by the given index number Index_num Value1 [Value2]
COLUMN Return he number of column which formula appears or the column number of given reference Reference
COLUMNS Return the total number of columns in a given array or reference Array
HLOOKUP Look up a value in table by matching first row Value Table Row_index [Range_lookup]
INDEX Returns the displayed value based on a given position from a range or an array Array Row_num [Col_num] [Area_num]
English English
en Englishaf Afrikaanssq Shqipar العربيةhy Հայերենaz Azərbaycan dilieu Euskarabe Беларуская моваbg Българскиca Catalàzh-CN 简体中文zh-TW 繁體中文hr Hrvatskics Čeština‎da Dansknl Nederlandset Eestitl Filipinofi Suomifr Françaisgl Galegoka ქართულიde Deutschel Ελληνικάht Kreyol ayisyeniw עִבְרִיתhi हिन्दीhu Magyaris Íslenskaid Bahasa Indonesiaga Gaeligeit Italianoja 日本語ko 한국어lv Latviešu valodalt Lietuvių kalbamk Македонски јазикms Bahasa Melayumt Malteseno Norsk bokmålfa فارسیpl Polskipt Portuguêsro Românăru Русскийsr Српски језикsk Slovenčinasl Slovenščinaes Españolsw Kiswahilisv Svenskath ไทยtr Türkçeuk Українськаur اردوvi Tiếng Việtcy Cymraegyi יידיש