top of page
Excel Function Guide
Expand Your Skills
A streamlined guide to Excel functions. Required arguments in dark gray, optional arguments in white. Also see our huge list of example formulas.
DATE & tIME
Create a date from year, month and day
Convert a date in text format to a valid day
Get ISO weeknumber for a given date
Get current date
Get the month as a number 1 - 12 from a date
Get the hour as a number 0 - 23 from a time
Get the minute as a number 0 - 59 from a time
Get the Second as a number 0 - 59 from a time
Get current date and time
Logical
Test multiple condition with AND
Generate the logical value FALSE
Test for a specific condition
Detect and handle ERRORS
Detect and handle NA
Reverse arguments or results
Test multiple conditions with OR
Generate the logical value TRUE
Perform exclusive OR
LOOKUP and REFErence
Test multiple condition with AND
Generate the logical value FALSE
Test for a specific condition
Detect and handle ERRORS
Test multiple condition with AND
Generate the logical value FALSE
Test for a specific condition
Detect and handle ERRORS
Test multiple condition with AND
Detect and handle ERRORS
Test for a specific condition
bottom of page