Get the Dates

[anneb_87]

Hi Experts!

I need to get the deadlines:

Client	Deadline
A	21st - 25th of the Month
B
C
D

Here is the source file:

Date Range	10th - 15th of the Month	16th - 20th of the Month	21st - 25th of the Month	26th - 31st of the Month	1st - 5th of the Following Month
# of Clients	9	14	22	15	10
Client List
Monthly
	B	J	E	A	F
		D		K	L
				G
Quarterly
	I	H

Is this possible?

 

[Peter_SSs]

in the Account Listing tab, column A had the account name then column G had the Funding type

That is a change from your sample in post 7 where they were in adjacent columns and does require a bit more of a change.

See if this (still with Ctrl+Shift+Enter) is closer to the mark. You will need to adjust the ranges in Account Listing but don't use whole column references. If you do, you are forcing the formula to process over 2 million cells! That will impact the performance of the sheet.

{=COUNT(SEARCH("|"&$C$21:$G$45&"|"&$B16&"|","|"&TEXTJOIN("|",1,'Account Listing'!$A$31:$A$34&"|"&'Account Listing'!$G$31:$G$34)&"|"))}