How to calculate time between two dates in Years, Months & Days [Excel Formula]
Let’s say you have two dates in the cells D4 & D5 as above. You want to find out the duration in years, months & days between both. We can use the good-old DATEDIF formula for this.
Calculating Critical Path using Excel Formulas [Project Management]
Do you know that we can easily calculate the critical path for a project using Excel formulas?
For a long time, it has been tricky to calculate the Critical Path using Excel formulas. But thanks to the arrival of new Dynamic Array functionality in Excel, we can now calculate critical path. In this article let me describe the approach with an example.
Put on your hardhats, this one is going to blow your minds.
Top 10 Accounting KPIs and How to Calculate them in Excel?
We can calculate any Finance & Accounting KPI values using Excel easily. In this article, I am sharing the top 10 accounting KPI calculations. These are… Topics ? Net Profit Margin Net Profit Margin = Net Profit / Sales Positive profit margin indicates business is profitable while negative indicates the business is in loss. ? […]
How to write complex Excel formulas (hint: it’s a lot like LEGO)
Writing advanced formulas is a lot like LEGO. Use what you already have and combine them in creative ways. Let me demo with 5 examples.