Hi there, I came across this function which calculates how many days occur between two dates:
=SUM(N(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=4))
I'm trying to dissect this formula to understand it better but the part I'm struggling with is the "INDIRECT(A1&":"&A2)" function. I'm not sure what job...