Calculating days

[Otabek]

i need formula to calculate days between 2 date without sundays, anyone can help?

[Aurelien]

Hi @Otabek

I would suggest a combination of TOTALHOURS() and a tips from @AleksiAlkio :

TOTALHOURS([EndDate]-[StartDate])/24
-
(
  HOUR(
    EOWEEK([EndDate])-EOWEEK([StartDate])
  )
  /24
  /7
  +
  IFS(WEEKDAY([EndDate])=7,1)
)

For reference:

Solved: Number of Saturdays between given two dates - Google Cloud Community

WORKDAY() - AppSheet Help

TOTALHOURS() - AppSheet Help

EOWEEK() - AppSheet Help

EDIT :

Thank you @jballester

[jballester]

I think some brackets are missing.

TOTALHOURS([EndDate]-[StartDate])/24
-
(
  HOUR(
    EOWEEK([EndDate])-EOWEEK([StartDate])
  )
  /24
  /7
  +
  IFS(WEEKDAY([EndDate])=7,1)
)