How does EXCEL automatically calculate the increase of a fund in the past month?
Your data here is less than 40 days, and there is no monthly comparison of the data for two months, let alone three months and six months;
You can use the month (), day () and weeknum () functions to extract the month, day and week as auxiliary columns, and then sum them with the sumif () condition to calculate the required increments.