How to take a month figure in excel?

Asked By Asheley Madison 10 points N/A Posted on - 07/29/2012

I believe that you can help me with this problem if you have an experience in excel. I have an excel sheet including purchase details from customers.

Please see the image below. This is only a sample.

I want to extract balance figure out at every month end (Only the balance at month end). Can help?

• Status: Open
• Question Views: 970
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 0 points N/A #134422

How to take a month figure in excel?

When considering your requirement I think we are able to find a solution by using Microsoft excel functions. I will use some basic functions in order to solve your matter.

 I will take the same example that you have been taken.

I am going to use the “if” and “month” functions in this case.

First go to the Cell F2 and type the following formula. There are many ways that you can apply these functions. However, I will give the formula directly.

=IF(MONTH(A2)=MONTH(A3),"",E2)

Now copy the same formula to below cells as shown in the below picture.

Now you can see the result that you expected.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 07/29/2012
• Question Category: MS Excel