Forum Discussion
Solved
Calculating Recurring Time Between Start and End Date
Hello all! I'm trying to visualize the total of expected inspections per month. Example data: Employee Number of Inspections Expected Frequency (days) Date Start Date End Adam ...
Ashish_Mathur
Super User
Super UserHi,
So for Adam you want the daes to increment by 10 days starting from March 1, 2022 and go upto August 31, 2022. How should it be for Brigette - 1 every 5 days? Please show the expected result in a simple Table format.
Hello Ashish_Mathur !
You're correct about Adam! Here is a clarification in text:
- About Adam: He is expected to do 1 inspection every 10 days starting on March 1, 2022 and ending on August 31, 2022.
- About Brigitte: She is expected to do 3 inspections every 10 days starting on May 1, 2022 and ending on October 31, 2022.
Result expected in table format:
Employee january february march april may june july august september october november december Adam 0 0 3 3 3 3 3 3 0 0 0 0 Brigitte 0 0 0 0 6 6 6 6 6 6 0 0
Thank you in advance!- Ashish_Mathur
What happens in Feb in which there are less than 30 days?
Here is an example of what could happen in February. In this example consider starting date as February 1st, 2022 and 1 inspection in each 10 days:
I'm having trouble creating a table that shows this behavior.
Thank you for the reply.
