CODEWITHSUNDEEP
excelformula
Yan LimaBenua
Yan LimaBenua

Reputation: 85

Simple count date with month by month

I want to ask a formula that can automatically create the number of days from a date line. Then can be categorized based on the number of days in a month. I created a sample table like in the picture. And date data beside it. anyone can help??

data sample

Upvotes: 0

Views: 236

Answers (1)

Egan Wolf
Egan Wolf

Reputation: 3573

Here's the formula to count Mondays:

=NETWORKDAYS.INTL(DATE(2017,MONTH(1&T8),1),EOMONTH(DATE(2017,MONTH(1&T8),1),0),"0111111")

For Tuesdays change last param to "1011111" and so on. I guess "July" in your table is in T8. If not, change both T8 to the cell where "July" is. After filling first row, you can drag or copy it to the remaining rows.

There is a way to take days' names from your table instead of typing "0111111", but it will make formula look much more complicated.

Upvotes: 1

Related Questions