kunalexceltip.com

Excel DATEDIF, EDATE, EOMONTH and YEARFRAC functions

Post author:Kunal
Post published:August 19, 2024
Post category:Excel Functions
Post comments:0 Comments

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.

Excel TODAY, NOW, DATE, DAY, MONTH and YEAR functions

Post author:Kunal
Post published:August 18, 2024
Post category:Excel Functions
Post comments:0 Comments

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

Excel IFS VLOOKUP with IFERROR and IFNA functions

Post author:Kunal
Post published:August 16, 2024
Post category:Blog
Post comments:0 Comments

Here, we will learn how to use the Excel logical functions: IFERROR and IFNA. Later, we will also learn how to use IFS VLOOKUP with IFERROR and IFNA.

Excel double XLOOKUP with SUM and IFERROR

Post author:Kunal
Post published:August 15, 2024
Post category:Excel Formulas
Post comments:0 Comments

Here, we will learn how to use the Excel logical function: IFERROR. Later, we will also learn how to perform multiple XLOOKUPs to SUM with the IFERROR function.

Combining and sorting unique arrays horizontally using Excel HSTACK function

Post author:Kunal
Post published:August 14, 2024
Post category:Excel Functions
Post comments:0 Comments

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.