Forum Discussion
Auto Sum cells up to todays date
Hi, I want to Sum the Gangers Allowance in row 8. I used the formula =SUMIFS(E8:AM8, E6:AM6, "<="&TODAY()) to auto-sum only the hours from week 1 up to the current date. this worked fine wh...
Enter the actual dates in row 7, formatted with the custom format ddd, so that they display Mon, Tue, Wed, etc., just as now.
You can then use
=SUMIFS(E8:AM8, E7:AM7, "<="&TODAY())