Technology Blog

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

Now, THIS is really fascinating - I've never really given this any thought whatsoever, but it's rather dazzling to see it is presented this way.

I certainly thought this was enlightening. Didn't even realize we knew much beyond our sun ....
It's a big universe.

Antares is the 15th brightest star in the sky. It is more than 1000 light years away.

Are you looking for the formula to calculate Growth Rate in Excel?

If you want to calculate growth rate between two months sales you can use following formula for that.

Growth Rate = ( ( Current Month Sales - Last Month Sales ) ^ 1 ) – 1

Are you looking formula to calculate annual growth rate?

The Growth formula in Excel is an array formula meaning that it takes several arrays of data as input and outputs an array of data which can be difficult to understand if your knowledge of statistics is not what it used to be.

Annual Growth Rate = ( ( Current Month Sales - Last Month Sales ) ^ ( 1 / ( Periods – 1 ) ) ) – 1

The formula for CAGR is not difficult. For calculating growth from a single start time and a single end time it's sufficient. In other words, if we have a value for revenue in Year 1 and a revenue figure for Year 10 and we aren't concerned about the years between we would set up the spreadsheet shown below, given that the formula is: