Number of saturdays and sundays between two dates

[Anonymous]

Hi,

I have two dates, a start datetime 29-04-2019 15:00:00 and an end datetime 04-05-2019 15:00:00, is it possible to make it count how many saturdays and sundays i have between these two dates, so in this case i have one saturday, and if the end datetime was 05-05-2019 15:00:00, i would have one sundays aswell.

Its fine with two columns one for saturdays and one for sundays.

Best regards ML

[ZunzunUOC · Accepted solution]

Hi @Anonymous , I advice the next:

I would create a calendar table with the next columns:

Date (maybe autocalendar)

Saturday= SWITCH(WEEKDAY(Calendario[Date]);7;1)

Sundays= SWITCH(WEEKDAY(Calendario[Date]);1;1)

Then, on your table, create the next calculated columns:

NumSat = CALCULATE(SUM(Calendario[Saturday]);DATESBETWEEN(Calendario[Date];Table1[STARDATE];Table1[ENDDATE]))

NumSun = CALCULATE(SUM(Calendario[Sunday]);DATESBETWEEN(Calendario[Date];Table1[STARDATE];Table1[ENDDATE]))

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I have a two coloumns start date and end date, i want to create a new coloumn and calculate how many fridays are there.