Current Week Forumula

[jrusso]

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

 

[jamtay317]

try this =SUMIFS(PROFIT,WIN,"<>P",WIN,"<>"&"",BET_DATE,">"&TODAY()-(WEEKDAY(TODAY(),2)-(7-WEEKDAY(TODAY(),2))),BET_DATE,"<="&TODAY()+(7-WEEKDAY(TODAY(),2)))

 

[jamtay317]

please let me know if it works

 

[jrusso]

please let me know if it works

Jams it seems to work!!

Now what would current month formula be if such a thing

Thanks

 

[jamtay317]

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

 

[jrusso]

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

That one I get error messages


too few arguments

 

[jamtay317]

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