Forum Discussion
Time between date look up and return value
Hikimbirch2,
good that you asked. By your change at the beginning of the line it would not have worked. In addition, there was a change in the structure of the data. The line below Trip # was no longer empty but already contained the first record. Therefore I changed the structure now completely and worked with filters. But you also got a summary of the data > 30 days. I hope you like it.
If you review you'll see that the rows are actually a repeat of annual time periods running 30 June 2021 to 30 June 2022. Then repeats in this annual cycle multiple times.
There's a number of 30 day period between trips which I need to flag. Any thoughts on this?
- Hi dscheikey - have attached v3.
This is super manual but hopefully show you what I mean. The data runs in annual periods from 30 June 2021 to 30 June 2022.
Within these date ranges I need to know if there are any period equal to or greater than 30days between dates including the start and end date.
What's probably needed first is to split the data into annual period 1, annual period 2 etc?
Hopefully this makes sense!Hikimbirch2,
I have made a new attempt. You didn't do your example very carefully. I hope I have done everything right now anyway.
There was an error in line 1592-1594. Here no date was deposited to a Trip at all. That leads with my formulas then to a calculation error. I did not want to rewrite everything again to react differently in case of an error. There I have the entry simply replaced by the date of the previous trip. The original cell entry is in cell K1594.
- Apologies for the extra work and also my delayed reply. I was travelling since our last discussion. Going to review now and hopefully all makes sense/ works. Will confirm shortly 🙂