Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

10000+ Copies Already Downloaded

Category Archives for Formulas

Sum Values Between Two Dates

how to sum values between two dates in excel

Let’s say, you are working in a trading company and your boss tells you to get the total sales amount for last 15 days. In this case, you need to sum sales amount from the current date to 15 days prior. Here, you have a range of dates which actually includes total 15 dates and […]

Check it out now

Get Last Day of a Month

how to get last day of a month

Sometimes you need to use the last day of a month in a calculation as a completion date, due date, or as a target date. You can easily add a month’s last date manually but there are some formulas which can help you calculate it. And, the best way to calculate it by using EOMONTH […]

Check it out now

Get Month from a Date

how to get month from a date in excel

Dates are an important part of data. It can help you to capture your data in a better way and it’s easy to use dates in further analysis. And, the best part is you can also modify dates as well and use them in your own way. Normal dates, when you are working in excel […]

Check it out now

COUNTIFS and COUNTIF With OR Logic

how to use or logic with countif and countifs

Two days back I wrote about how you can use OR logic in SUMIFS and SUMIF. And today, I want to show, that you can also use the same OR logic and multiple conditions in COUNIFS and COUNIF. Even you can create dynamic criteria for OR logic in COUNIFS and COUNIF. Have you ever faced a […]

Check it out now

4 Quick Methods for Deleting Spaces in Excel

how to delete extra spaces in excel

A clean data is our birthright. But sometimes, we are not able to access it. Sometimes, we are not able to use our data as the way we want to use it. And, the one biggest reason which makes our data unable to use is unwanted spaces in a cell. So, if you want to […]

Check it out now