Forum Discussion
How to create a Dynamic list of dates
- Aug 10, 2021
Perhaps you mean something like in attached.
Hogstad_Raadgivning Thank you for your formula. I see the ranges go to C and D 383 but it only returns 2 results and the spill is in a row not a column. Not sure why....But it is much closer to what I am seeking. I have attached an expanded version of the sample workbook with manually inputted (random) dates to show what it should visually look like. I found that the simple COUNTA function will count the dates when like this (but do not know whether this works with a spill function, I assume it will ) I have also given in a post more detail of the functionality of the workbook if it would help to read this.
Thankyou again Geir but still not working.
- SergeiBaklanAug 10, 2021Diamond Contributor
Perhaps you mean something like in attached.
- Cambosity100Aug 10, 2021Brass ContributorThankyou so much ! That is exactly what I was looking for. I knew it would be something simple just couldn't find the right function. Its perfect 🙂 Thankyou to all have contributed to getting to this point. Nikolino and Geir your time is appreciated and valued 🙂
- SergeiBaklanAug 10, 2021Diamond Contributor
Cambosity100 , glad it helped
- Hogstad_RaadgivningAug 10, 2021Iron Contributor
Only returns 2, because there is only 2 for Februar: Whu would you the filtered results in rows? And not columns, so you can have one row for each month?
=TRANSPOSE(FILTER(C4:C383;(MONTH(C4:C383)=1)*(D4:D383<>"");"")) where 1 is january
=TRANSPOSE(FILTER(C4:C383;(MONTH(C4:C383)=2)*(D4:D383<>"");"")) where 2 is february, one for each monthAnd you can use Count (To count if numbers) with spill (#)
/Geir