Calculate how many mondays, tuesdays, wednesdays etc left in the current month?

[mdsurf]

Hi All, I am trying to figure out how to calculate the number of REMAINING mondays, tuesdays, wednesdays, thursdays, fridays, saturdays and sundays in the current month. Any idea on how to do this?

Thanks!

 

[Tetra201]

Try these:

=NETWORKDAYS.INTL(TODAY(),EOMONTH(TODAY(),0),"0111111") for remaining Mondays,
=NETWORKDAYS.INTL(TODAY(),EOMONTH(TODAY(),0),"1011111") for remaining Tuesdays, etc.

 

[lrobbo314]

Another one, but honestly, Tetra's is a better formula. The 6 refers to the day of the week you are counting, 6 is a Friday.

=SUMPRODUCT(--((WEEKDAY(Start+(ROW(INDIRECT("1:" &(End-Start)+1))-1),1))=6))

 

[mdsurf]

Thank you both very much for the prompt replies and help! One more follow up question. I have an excel where row 1 is the date and row 2 is revenue on that date. Is there a way to sum the revenue of the last 4 mondays? last 4 tuesdays etc? Basically I'm trying to build a projection calculator for my business to help me estimate my revenue for the month.

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 500"]
<tbody>[TR]
[TD]July 28[/TD]
[TD]July 29[/TD]
[TD]July 30[/TD]
[TD]July 31[/TD]
[TD]Aug 1[/TD]
[/TR]
[TR]
[TD]$500[/TD]
[TD]$700[/TD]
[TD]$600[/TD]
[TD]$800[/TD]
[TD]$900[/TD]
[/TR]
</tbody>[/TABLE]

I'm using a layout similar to above.

Thanks!

 

[Dave Patton]

Excel 2010
	A	B	C	D	E
1	Wed 01-Aug-18	Thu 02-Aug-18	Fri 03-Aug-18	Sat 04-Aug-18	Sun 05-Aug-18
2	100	100	100	100	100
3
4
5	Monday	1	400
6
1d

Cell Formulas
Range	Formula
C5	=SUMPRODUCT(--(WEEKDAY(A1:AE1,2)=B5),(A2:AE2))

 

[Tetra201]

... Is there a way to sum the revenue of the last 4 mondays? last 4 tuesdays etc?..

Try these:

=SUMPRODUCT((A1:ALL1=WORKDAY.INTL(TODAY(),-{1;2;3;4},"0111111"))*A2:ALL2) for the four last Mondays,
=SUMPRODUCT((A1:ALL1=WORKDAY.INTL(TODAY(),-{1;2;3;4},"1011111"))*A2:ALL2) for the four last Tuesdays, etc.