Advance Excel Day 6 - Logical Functions and DateTime Functions
Topics Covered for Today
Logical functions
If & Nested If Functions with AND/OR
IF
AND
OR
IFERROR
FALSE
IFS
IFNA
TRUE
SWITCH
Data & Time Functions
DATE
TODAY
WORKDAY
NOW
DATEVALUE
DAY
MONTH
YEAR
DATEDIF
WEEKNUM
WORKDAY.INTL
NETWORKDAYS
NETWORKDAYS.INTL