I have a list of people with a start and stop date for a particular treatment. These dates are in different columns
[PatientID] [Start_date] [Stop_date]
The dates go back to the 1980's up until today. I want to create a table from this with the number of people on this treatment on a particular day, and then for every day over this time period.
I think that i should be using the SUMPRODUCT FORMULA but cant get this right. I have searched for equivalent threads and cant seem to find that this has been asked although i would have thought that this has been asked before. Can anyone point me in the right direction please?
Bookmarks