Return dates from one data table to records in a different table with start and end date

[Gretsch308]

Hello! I am trying to get the values from column "T" into column "O" when the values in "T" are between the values in "G" and "H". I have included the data. Both sets of data will eventually be named tables.




Example.xlsx

[Gretsch308]

I think I solved this. There may be other ways. This is how I did it. I would still be interested in alternative solutions. Thanks for looking!



Solution.xlsx

[dwint]

the formula should be like this

=IF(MONTH(A2)+1=MONTH(B2),DATE(YEAR(A2),MONTH(A2)+1,DAY(1)-1),"")

copy down

[Gretsch308]

dwint FTW!!!! That worked perfectly! Much cleaner than my solution as well. Thanks!!!

[Gretsch308]

I think the formula has a small flaw. If the first day or last day of the month is in either the start date or the end date, the formula will return a blank cell.