79808559

Date: 2025-11-04 06:17:52
Score: 1
Natty:
Report link
Time = 
IF(
    NOT(ISBLANK(Sheet1[Start Date])) &&
    NOT(ISBLANK(Sheet1[End Date])),
    NETWORKDAYS(
        Sheet1[Start Date],
        Sheet1[End Date],
        IF(
            OR(
                Sheet1[Country Name] = "Saudi Arabia",
                Sheet1[Country Name] = "Egypt"
            ),
            7,
            1
        )
    ) - 1,
    BLANK()
)
Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: devrinc