Forum Discussion
How to create a Dynamic list of dates
Perhaps you mean something like in attached.
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
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 🙂
Cambosity100 So, I work for a NDIS Provider supplying supports to people with disability. There are about 60 clients and 40 odd staff. I need to do a self audit of the year past of shift notes in hard copy submitted by staff over the year. I will be cross referencing from the years roster but need to identify if there are missing shift notes and why. There can be a whole host of reasons. This spreadsheet will identify where there are potential issues to be looked at so it is essential to know for each client what dates the issues occur and how many are still unresolved. I have expanded the work book to 4 clients to give a better glimpse of what I am doing. I hope this clears it up 🙂 And once again I thank you for your interest in this 🙂
Here you can see a small example with a pivot table in client 1.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)