# Excel Formula ## How to Use Excel DATE Function?

In general, dates are the significant ones for making any events, programs, functions, etc. Because we should decide the time of the event on a… Read More »How to Use Excel DATE Function? ## How to Use Excel TRUE Function?

Generally, TRUE or FALSE are two logical expressions representing 1 and 0 respectively. On that note, if we want to check whether the given condition… Read More »How to Use Excel TRUE Function? ## Formula to Count Occurrences of a Character in a String in Excel!

Sometimes, we want to find the occurrences of a specific character in a word. Instead of counting it manually, we can use the Excel COUNTCHAR… Read More »Formula to Count Occurrences of a Character in a String in Excel! ## Formulas to Find Maximum Value with Multiple Criteria in Excel!

The maximum value is the largest number of a set of values. Sometimes, we want to get the largest value from the list, it can be… Read More »Formulas to Find Maximum Value with Multiple Criteria in Excel! ## Formulas to Rank Items with One or more Criteria in Excel!

Excel has a RANK function, so you can calculate the rank of each number that stands in a list in your spreadsheet. Instead of using… Read More »Formulas to Rank Items with One or more Criteria in Excel! ## Formulas to Sum Columns based on Adjacent Criteria in Excel!

Sometimes you need to sum values in columns based on adjacent criteria in a range, What would you do? We suggest you use the formula… Read More »Formulas to Sum Columns based on Adjacent Criteria in Excel! ## Formulas to Count Cells with Multiple OR Criteria in Excel!

In Excel, how could we count the cells with multiple criteria? There is a formula with the COUNTIF function in Excel. By applying it to… Read More »Formulas to Count Cells with Multiple OR Criteria in Excel! ## Formulas to Get Content of Given Row & Column in Excel!

In Excel, how could we extract the content from a specified row and column? There is a formula with INDIRECT and ADDRESS functions in Excel.… Read More »Formulas to Get Content of Given Row & Column in Excel!