**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I need to extruct data from column B for a particular month stored in column C as a date in format of dd/mm/yyyy

Solved by E. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
28/07/2018 - 01:43

Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)

Excelchat Expert
28/07/2018 - 01:44

Okay, from what you've posted, it seems you want to extract data from column B based on the values in column C. May I kindly ask if you can provide the file you're working on so we could get a better grasp of the situation. Thanks!

Excelchat Expert
28/07/2018 - 01:48

I see that you've pasted data in our document preview. Column B seems to contain brands while column C contains dates. However, for the columns G to R, they seem to be wanting to get the GRPs, not the brand per se. Can you please further clarify on this? Thanks!

Excelchat Expert
28/07/2018 - 01:51

Hello? :)

Excelchat Expert
28/07/2018 - 01:54

Okay, I've included a formula in columns G to R that captures the GRP value for the month based on the date in column C.

Excelchat Expert
28/07/2018 - 01:55

So in row 2, we have 20/06/0216 as our date. The month would thus be in June, and the GRP value of 67 should show under the Jun GRP (column L) on the right side of the table.

Excelchat Expert
28/07/2018 - 01:55

The formula used is as follows: =IF(TEXT(DATE(RIGHT($C2,4),MID($C2,4,2),LEFT($C2,2)),"MMM")=LEFT(G$1,3),$D2,"")

Excelchat Expert
28/07/2018 - 01:57

This formula first checks IF the date in column C would match the month header under columns G to R. If it matches, it copies over the GRP value of that date under the corresponding month.

Excelchat Expert
28/07/2018 - 01:58

If this do not match, it just leaves the cell as blank.

Excelchat Expert
28/07/2018 - 01:58

If you look at the document preview, you'll notice that we have the sheet "Copying GRP" and "Copying BRAND". In "Copying GRP", it copies the GRP value under the following months.

Excelchat Expert
28/07/2018 - 01:59

In "Copying BRAND", the formula in this does the same formula, just that it copies the BRAND, not the GRP.

Excelchat Expert
28/07/2018 - 02:00

I can see that your avatar is still here in the session. Please do respond either in the document preview or thru this chat for any clarifications.

Excelchat Expert
28/07/2018 - 02:02

I can see you're checking the formula in cell H3. Please do extend the session if you need more time for clarifications.

Excelchat Expert
28/07/2018 - 02:02

Btw, you can download a copy of the document preview by going to File > Download as > Microsoft Excel (.xlsx). The formulas will be downloaded as well. :)

User
28/07/2018 - 02:02

Thank you.

Excelchat Expert
28/07/2018 - 02:02

Nice! You can now end the session via the button on your upper right (sorry, can't do it from our end). I would also appreciate it if you can leave a great feedback after this.Thanks so much for using Got it pro and have a nice day! :)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*