i have a list of dates (days with HH:MM:SS in num format) which cover a period of time in the past. The set is not a complete set of dates, there are gaps. I do now want to find the following three dates based on one selected date:
one week ago: same day in prior week. if that doesnt exist, then the first possible day before that day
one month ago: same day in prior month. if that doesnt exist, then the first possible day before that day
one year ago: same day in prior year. if that doesnt exist, then the first possible day before that day
I have attached the set of dates as a txt file to this post.
