Hello, I have a column with the subject number and a column with the dates. I'm trying to find the number of dates within each 7 day period that have at least one occurance, starting from the first date listed for each subject. There is also a condition column where I only want the dates to be counted if there is at least one occurance with condition X. Each subject has a maximum of close to 12 weeks of measurements so if its possible I'd like to average the number dates in the first week for all subjects and average the values for the second week and so on. I've added a speadsheet with a sample of the data where I've manually put values in for the each 7 day period for each subject and the averages. I don not need a formula for the date range column I only added that for reference. If there's any further clarification needed let me know. Thanks for your time.
Bookmarks