Forum Discussion
How to create a Dynamic list of dates
Perhaps you mean something like in attached.
=COUNTA(D4:D34)
In case you want to count the number of dates.
Please have a look at the inserted file.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- At the same time I have just used the Counta function after manually creating dates in H4 an it counts them beautifully. That does solve that half of the problem 🙂 Thank you Nikolino 🙂
NikolinoDE Thankyou for your response Nikolino. Unfortunately this is not what I need. It is not how many ? marks per month but a list of the dates next to them. Also, as there will be other letters in Column D it does really need to then, I believe, count the dates that appear in that list. What you have seen is just a small sample of much larger spreadsheet and I need to access the dates to resolve the problems associated with them. But thankyou for your 1st reply. 🙂 Peter
- You write: Also, as there will be other letters in Column D it does really need to then, I believe, count the dates that appear in that list.
if I may ask, what letters?
I only see a question mark
Please explain exactly the function you want to create and use or add real data as far as possible (please, no sensitive data).
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)- No probs give me 10 mins 🙂
