

Category Archives for "Formula Hacks"

Home >>
Blog >>
Formula Hacks

0 How to SUM values between two dates (using SUMIFS formula)

Formula to sum between dates using cell references

When you’re working with datasets that have dates, you would often find yourself trying to do calculations based on the dates. For example, if you have the sales data for a month, you may want to know the total sales that have happened between two given dates or the total sales made on weekends vs […]

2 Excel Filter Function – Explained with Examples + Video

Watch Video – Excel FILTER Function Examples Office 365 brings with some awesome functions – such as XLOOKUP, SORT, and FILTER. When it comes to filtering data in Excel, in the pre-Office 365 world, we were mostly dependent on Excel in-built filter or at max the Advanced filter or complex SUMPRODUCT formulas. In case you […]

0 Calculate the Number of Months Between Two Dates in Excel (Easy Formulas)

Difference between YEARFRAC and DATEDIF and YEAR & MONTH function

If you manage multiple projects, you would have a need to know how many months have passed between two dates. Or, if you’re in the planning phase, you may need to know the same for the start and end date of a project. There are multiple ways to calculate the number of months between two […]

0 How to Sort by the Last Name in Excel (Easy Guide)

Watch Video – How to Sort By Last Name in Excel If you work with names datasets, sorting it is one of the common tasks you would have to do often. It’s quite easy to sort data alphabetically based on the full name, where Excel uses the first character of the name to sort. But […]

0 How to Calculate Square Root in Excel (Using Easy Formulas)

Append square root symbol to a value using ampersand

It’s amazing how you can find multiple ways to do the same thing in Excel. After all, there are so many awesome functionalities and functions. A really simple and often needed task is to calculate the square root in Excel. And as I said, there are multiple ways you can do that in Excel (formulas, […]

0 Convert Time to Decimal Number in Excel (Hours, Minutes, Seconds)

Convert Time to Decimal using the CONVERT function

By default, date and time are saved as numbers/decimals in Excel. But you often see it in different formats because of the way the cells have been formatted. For example, in the below example, the value in column A and B is the same, but these are displayed differently because of the format. And one […]

0 How to Remove Time from Date/Timestamp in Excel (4 Easy Ways)

Excel allows you to display data in many different formats. And there are way too many to choose from when it comes to dates and time data in Excel. And since there are so many formats, there are also ways to edit and modify these. One common thing many people need to do often in […]

1 2 3 … 8 Next »