Count number Fridays in a given period

[Servatec]

Hello Team, I have been struggling with counting a number day ( Monday, Tuesday, Wednesday etc) in a [Start date] and [End date]

[LeventK]

@Servatec
Should [StartDate] and [EndDate] be counted if either of them falls into Friday? Try with this first:

NUMBER((WEEKDAY([StartDate] - 6)-[StartDate]+[EndDate])/7)

Bear in mind that, the above expression also counts the Fridays if the Start and End dates also falls into Friday. Provided you want to omit them, you need to set an IFS expression:

IFS(
	AND(
		WEEKDAY([StartDate])=6,
		WEEKDAY([EndDate])=6
	),NUMBER((WEEKDAY([StartDate] - 6)-[StartDate]+[EndDate])/7)-2,
	OR(
		WEEKDAY([StartDate])=6,
		WEEKDAY([EndDate])=6
	),NUMBER((WEEKDAY([StartDate] - 6)-[StartDate]+[EndDate])/7)-1,
	TRUE,NUMBER((WEEKDAY([StartDate] - 6)-[StartDate]+[EndDate])/7)
)

[AlexM]

COUNT(SELECT(DatesTable[Date],AND([Date]>=[Start Date],[Date]<=[End Date],WEEKDAY([Date])=[DayToCount])))

I ended up with this, having [DayToCount] Enum to select the day.

[Servatec]

Great. Not necessarily fall on Friday but to count number of occurrences of a day with a given period start to end date

[AlexM · Accepted solution]

I am counting the days from my Shifts table.
By having the conditions <= and >= the selected dates are included.
Not to be included the just use < and >.

In the example below, only had 3 Monday shifts.

[Servatec]

[Servatec]

Trying implement your formula here I think finding it difficult to.

I want to use created (date) and today()
To get the number of Sundays.

[AlexM]

Replace [From} with [Created] and [To] with TODAY()

[Servatec]

Woooaoooh thanks a lot more than a magic