# Current Week Forumula

#### jrusso

##### Board Regular
I use a formula now to calculate last 7 days profit loss

=SUMIFS(PROFIT,WIN,"<>P",WIN,"<>"&"",BET_DATE,">"&TODAY()-7,BET_DATE,"<="&TODAY())

Now say I want a formula to calculate the current week only and the week starts on Monday and ends on Sunday

Thanks

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
try this =SUMIFS(PROFIT,WIN,"<>P",WIN,"<>"&"",BET_DATE,">"&TODAY()-(WEEKDAY(TODAY(),2)-(7-WEEKDAY(TODAY(),2))),BET_DATE,"<="&TODAY()+(7-WEEKDAY(TODAY(),2)))

please let me know if it works

please let me know if it works

Jams it seems to work!!

Now what would current month formula be if such a thing

Thanks

=sumifs(profit,win,"<>p",win,"<>"&"",bet_date,">"&(eomonth(today(),-1)+1),"<="&eomonth(today(),0)))

=sumifs(profit,win,"<>p",win,"<>"&"",bet_date,">"&(eomonth(today(),-1)+1),"<="&eomonth(today(),0)))

That one I get error messages

too few arguments

=sumifs(profit,win,"<>p",win,"<>"&"",bet_date,">"&(eomonth(today(),-1)+1),bet_date,"<="&eomonth(today(),0)))

Replies
1
Views
239
Replies
3
Views
107
Replies
7
Views
472
Replies
6
Views
188
Replies
0
Views
261

1,207,199
Messages
6,077,023
Members
446,251
Latest member
dpf220

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back