Forum Discussion
Solved
SUMIFS Using todays Date
I think SUMIF is the way to do this. I'd like a cell (E5 in example) to give me the sum of cells (F5:L5) for the current week (F4:L4) by using todays date (A2) and then be able do it for the date ran...
- Thank you, I will plug it in and check it out. I'm trying to figure it out in 365 but ultimately I'd like to move it to Sheets so that I can share it easily
It depends do you have in rows 3 and 4 dates formatted as weekday and d/m, or texts?
SergeiBaklan Row 3, F3:Z3 are text. Row 4, F4:Z4 are formatted as dates D/M
- Thank you, I will plug it in and check it out. I'm trying to figure it out in 365 but ultimately I'd like to move it to Sheets so that I can share it easily