Forum Discussion
How to create a Dynamic list of dates
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.
Perhaps you mean something like in attached.
- Thankyou 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 🙂
Cambosity100 , glad it helped