Forum Discussion
Solved
Autofill a Date Range within a Formula
I use many spreadsheets where I am counting the number of X per a date range. Is there anyway I can autofill the date range within my formulas that are setup to count? Here is a pretty simple one...
=SUMIFS(C:C,A:A,">="&EDATE(E2,0),A:A,"<="&EDATE(E2,1)-1)
You can enter this formula in G2 and copy down.
Maybe this can be done with the more complex formula as well.
=SUMIFS(C:C,A:A,">="&EDATE(E2,0),A:A,"<="&EDATE(E2,1)-1)
You can enter this formula in G2 and copy down.
Maybe this can be done with the more complex formula as well.
- I've never used the EDATE function before but I think with some modification, this could work for my current setup. Thank you!
