Excel Functions

Here, we will learn how to use the Excel date functions: WEEKDAY and WEEKNUM. Later, we will also learn how to create weekday abbreviation.

Here, we will learn how to use the Excel date functions: DATEDIF, EDATE and YEARFRAC. Later, we will also learn how to calculate expiry dates.

Here, we will learn how to use the Excel date functions: TODAY, NOW, DATE, DAY, MONTH and YEAR.

Here, we will learn how to use the Excel dynamic array function: HSTACK. Later, we will also learn how to combine and sort unique arrays horizontally.

Here, we will learn how to use the Excel dynamic array function: VSTACK. Later, we will also learn how to combine and sort unique arrays vertically.