Find today's date in a text string in a column and return this string and....

Hi,

Can someone please help me to figure out a formula for finding today's date (032715), concatenated in the end on text/number string in column 'G' in the attached spreadsheet (Sample DATA) and return in 'Sheet 2' tab the corresponding value from column 'A' (Campaign ID by Email) and next to it also return strings that contain today's date for 5 Day and 28 Day emails. The report always will contain today's date in 6 digit format (mmddyy), 032715 in this instance.

Thank you so much!!!

Sample DATA.xlsb

Hi FDibbins,

You are great as usual! This formula works well for the pivot table, but ideally, to make the Excel Template "clean" because other people will be using it, I would like this formula to return only the values with today's date from column 'G' in the attachment and corresponding to them values from column 'A', so it would look like below. In addition, the below would be in a different tab "Sheet 2" in the attachment.

Would it be possible to modify the formula to account for these conditions? The number of rows in "DATA" table varies. And usually there are 4 values for 5 Day email and 4 values for 28 Day email in this report under 'Data' tab.

Four Campaign IDs for 5 Day email with TODAY’s date stamp:


Sheet 2
ColumnA Column B
5 Day 5day_latencyXXXXXX
5 Day 5day_latency_RZXXXXXX
5 Day 5day_retlatencyXXXXXX
5 Day 5day_retlatency_RZXXXXXX

Four Campaign IDs for 28 Day email with TODAY’s date stamp:

Sheet 2
Column A Column B
28 Day latencyXXXXXX
28 Day latency_RZXXXXXX
28 Day retlatencyXXXXXX
28 Day retlatency_RZXXXXXX

MUCH APPRECIATED!!!

P.S. I added reputation to your profile in the other thread.

The formula works perfectly! I just added another column where I applied this formula. So now pivot table includes this formula, which I modified slightly to return a campaign ID, not just date.

Thank you! Thank you!