Forum Discussion

xgp_62's avatar
xgp_62
Copper Contributor
Feb 14, 2024

Calculate days between dates excluding repeteated days

Hi, I have the following table with 3 columns: teacher, Initial & final date. Column  "Days" calculates difference in days for each row, but as some days are repeated with date ranges (highlighted),...
excel
Office Scripts
power bi
rachel's avatar
rachel
Steel Contributor
Feb 14, 2024

xgp_62 

 

Hi,

 

In the attached excel, column H lists all dates between 20/09/2022 and 18/03/2024.

Column I is checking whether or not "Teacher 2" is working on that date.

Cell I3 counts the number of dates where "Teacher 2" is working. and I believe that is what you are after.