Hello all.
I'm having a little trouble finding a built in excel formula for what I have in mind.
Lets say:
(B4:B12) has the same date of 2-1-2022
(B13: B16) has the same date of 2-2-2022
(B17:B42) has the same date of 2-3-2022
and so on all the way down to the current date, and variation in the number of days.
What I'm trying to do is in (D4:to end of Column B) summarize the dates.
D4 = 2-1-2022
D5 = 2-2-2022
D6 = 2-3-2022
The summary of dates, in column D, would go as far as the last date entered in column B.
For example, if the last date in column B ended with 2-17-2022, row 282, then the last entry in Column D would also end at 2-17-2022, only not in row 282. Basically in row 20 (I think) if B4 was 2-1-2022.
I would like to not use a pivot table.
Not sure if that makes sense.
Thanks for the help
I'm having a little trouble finding a built in excel formula for what I have in mind.
Lets say:
(B4:B12) has the same date of 2-1-2022
(B13: B16) has the same date of 2-2-2022
(B17:B42) has the same date of 2-3-2022
and so on all the way down to the current date, and variation in the number of days.
What I'm trying to do is in (D4:to end of Column B) summarize the dates.
D4 = 2-1-2022
D5 = 2-2-2022
D6 = 2-3-2022
The summary of dates, in column D, would go as far as the last date entered in column B.
For example, if the last date in column B ended with 2-17-2022, row 282, then the last entry in Column D would also end at 2-17-2022, only not in row 282. Basically in row 20 (I think) if B4 was 2-1-2022.
I would like to not use a pivot table.
Not sure if that makes sense.
Thanks for the help