Running Total Blocks of 6-month Periods
Hello! I'm trying to create a calculated column that keeps a running total of blocks of 6-month periods. For example, given the data below, I would want the dates to be formatted as such: 03/15/2020 - 08/19/2020 – 1 12/15/2020 – 05/10/2021 – 2 11/29/2021 – 04/27/2022 – 3 Any ideas? Thank you! Event Date 8/12/2020 8/19/2020 12/15/2020 2/4/2021 4/17/2021 5/10/2021 11/29/2021 3/2/2022 3/6/2022 4/26/2022 4/27/2022