Cheatsheet — Excel

This is my personal collection of cheatsheet for Excel.

Indian Number Format

[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0.00

Current Day, Month & Year

=MONTH(TODAY())    // Current month
=YEAR(TODAY())     // Current year
=DAY(TODAY())      // Current day of month. (Select type as number)

DATEIF

• Calculate difference between dates.

=DATEDIF(M4,TODAY(), "M")

IF ELSE

=IF(TRUE,4,5)

Last Value of Column

=LOOKUP(2,1/(B:B<>""),B:B)

IFERROR

• If formula can give error, this will help to handle that error.

=IFERROR (value, value_if_error)