User Profile
ecantu
Copper Contributor
Joined Aug 12, 2023
User Widgets
Recent Discussions
Define conscutive months
Hi everyone! I am trying to get the average length between two dates only for consecutive months. To get the average length between dates I am using =AVERAGE(DATEDIF(A2,A1,"d"),(DATEIF(A3,A2,"d",)...) But as you can see, not all months are consecutive and I only want the days between consecutive months (between A7&A6, A5&A4, A4&A3, etc...) Dates A1 7/12/2023 A2 4/18/2023 A3 3/22/2023 A4 2/22/2023 A5 1/25/2023 A6 9/7/2022 A7 8/10/2022 I was thinking of using AVERAGEIF but I don't know how to define consecutive months in the criteria. Thanks for the help!461Views0likes1Comment
Recent Blog Articles
No content to show