Example Related FunctionsDATE MONTH YEAR =MONTH(DATE(YEAR(date),2,29))=2If you want to test whether the year of a certain date is a leap year, you can ...

Example Related FunctionsEOMONTH NETWORKDAYS To calculate workdays per month, use the EOMONTH function together with the NETWORKDAYS function.In the ...

Example Related FunctionsIFERROR VLOOKUP =IFERROR(VLOOKUP(value,table,2,FALSE),"")If you want to hide the #N/A error that VLOOKUP throws when it can't ...

Example Related FunctionsVLOOKUP =VLOOKUP(val1&val2,data,col_index,0)One of the limitations of VLOOKUP is that it only handles one condition: the ...

Example Related FunctionsVLOOKUP =VLOOKUP(val&"",table,col,0)A common problem with VLOOKUP is a mismatch between numbers and text. Either the first ...

Example Related FunctionsVLOOKUP =VLOOKUP($A1,table,COLUMN()-x,0)There are times when you may want to use VLOOKUP with a dynamic column index. A common ...

Example Related FunctionsVLOOKUP =VLOOKUP(value,IF(test,table1,table2),col,match)To use VLOOKUP to retrieve values from two lookup tables, you can use ...

Windows shortcut  AltShift← Mac shortcut  ⌘⇧J This shortcut will ungroup selected rows or selected columns. Select whole rows or columns first ...

Windows shortcut  AltShift← Mac shortcut  ⌘⇧J This shortcut will ungroup selected pivot table items. If you want to ungroup a field, you only need ...

Windows shortcut  CtrlZ Mac shortcut  ⌘Z This shortcut will allow multiple levels of undo; each time you use it Excel will step back one level. ...