Category: Formulas

Time Value of Money

This post is a explainatory post for Financial Functions of Excel. In order to understand some of the financial functions, you need to have a...

Extract Text From String

If you need to extract text from string in Excel with a known character, there is an easy way of doing this with just one...

Subtotal Function

Subtotal function is a versatile function that can answer a lot of your needs all by itself. Besides it has some cool tricks in its...

Datedif Function

Datedif Function is used for calculating difference between two dates. I shows the results in days, months or years. Interesting thing is, Datedif Function is...