Find count of dates based on between two dates and update dates in another cell

Hi There,

I have two dates “From date” and “To date” in one sheet and another holiday date in next sheet.
I should get the “Total count of Holidays dates between from dates (column C) and To date (Column D) by referring holiday sheet date
And in next column those date should appear. I have update the sample.

Thanks and Regards,
Senthil Murugan

UDF:

Please Login or Register  to view this content.

Use:

=ConcatAll(IF(('Holiday Date'!$A$2:$A$11>=C2)*('Holiday Date'!$A$2:$A$11<=D2),TEXT('Holiday Date'!$A$2:$A$11,"dd-mmm-yy"),""),", ")

Enter with Ctrl+Shift+Enter.

Thanks it is working. just check with you column G, working through VB. Can this be made in excel formula without VB?

Hi kvsrinivasamurthy,

Thanks for the updates.

Holiday Date sheet, the list given sample, this may extend to 30 rows also, Therefore any option to give more range?
instead of assigning the details given in column h to p, this can be clubbed in one cell?

Thanks & Regards,
Senthil Murugan

Hi,
Thanks..
i was trying to extended the formula in Column G also and found that it is showing duplication dates in case if dates repeated twice in Holiday date sheet. is there way to fix this?
from column H we are extending to multiple cells based on the number of days given in Holiday sheet (Example 30 rows) is there way cut down this?

Regards.. Senthil Murugan

Hi kvsrinivasamurthy.. Thanks.