Calculate average days between dates continuously updating
Hi I am looking for a formula solution that calculates the average days between dates that appear in a row. The tricky part is that new dates are added to each row every so often. This is for a plant watering schedule in google sheets which you can view here: https://docs.google.com/spreadsheets/d/1_w5nqlQDtHTrepfhUWOeCXALR0vjBGW4cxq8-KxcaqU/edit?usp=sharing Each row keeps a record of the dates I water each plant. When I check the box in column D, the current date (i.e. today) is automatically created in column E and previous dates shift over 1 column - continuously adding the new dates I water the plants. I want a formula to calculate the average days between the dates that are in each row. But I also want the formula to account for the fact that new dates will be added, with the newest date to appear in column E and older dates extending back to columns F, G, H, etc to infinity... I want the average days to appear in Column C. The File I have shared is editable and you can trial how the sheet works there as it is a copy of my original sheet. Suggestions and solutions would be much appreciated!
Try
=arrayformula(iferror(AVERAGE(offset(E2,,,,sumproduct(--(E2:2<>""))-1)-offset(F2,,,,sumproduct(--(E2:2<>""))-1))))
and drag below
- How do nested functions get compiled?
- The "this" pointer and message receiving in D
- 64-bit executables with DMD
- GtkD with D lang on Fedora
- Why Android used Java concept instead of D language or C or C++? But Chromium web browser is in C++, its very complicated match
- How to use MongoItemWriter to write a List<T>
- Why a function with protected modifier can be overridden and accessible every where?
- Convert Unicode const(uint)* to a dlang character type
- Compiling D with Code::Blocks
- DMD vs. GDC vs. LDC
- Rendering a font in raylib using freetype
- Digital Mars D compiler; acquiring ASM output
- D Programming: openssl rsa forward reference compiler error
- D compiler DMD doesn't link object files
- OPTLINK: Warning 23: No Stack
- Is there a limit in the amount of temporary generated symbols during a project build using dmd 2.063?
- Is this the right way to combine Garbage collected with none Garbage collected code in D
- D compiler (Digital Mars D Compiler) throwing error
- Which D Compiler to Use?
- Splitting a string treating multiple whitespace as one separator
- Proper way of passing array parameters to D functions
- Detailed Valgrind internals documentation
- Is it possible, in D, to tell the garbage collector to not scan a particular pointer (or anything below it)?
- Iterate over key/value pairs in associative array in D.
- Dlang associative array of an array of strings keyed by a string has unexpected behavior
- How to repeat a statement N times (simple loop)
- Is worth the effort to learn D?
- ld: undefined reference to object I can see in objdump
- D using emplace
- How can I return JSON with HTTP code in Vibe.d?