Count no. of working days For Issue in a Issue Report or view | Community
Skip to main content
Kundanism
Kundanism
Level 10
February 13, 2025
Solved

Count no. of working days For Issue in a Issue Report or view

  • February 13, 2025
  • 1 reply
  • 608 views

Hi,

How to calculate no. of working days for an issue in a issue report as column?

I have created a new custom date field called as "Original Request Date".

 

I have two conditions expected to be together in one text code;

1) Issue open since: If (Entry Date) less than ((Original Request Date) show value (Current Date) – (Entry Date))

2) If (Original Request Date) less than ((Entry Date) show value (Current Date) – (Original Request Date))

 

Looking your help and guidance.

Have a nice day.

 

BR

Kundan.

 

Best answer by KellieGardner

You can use nested if statements to do this. 

 

valueexpression=IF({entryDate}<{DE:Original Request Date},WEEKDAYDIFF({entryDate},$$TODAY),IF({DE:Original Request Date}<{entryDate},WEEKDAYDIFF({DE:Original Request Date},$$TODAY)))

 

 

 

 

1 reply

KellieGardner
Community Advisor
KellieGardnerCommunity AdvisorAccepted solution
Community Advisor
February 13, 2025

You can use nested if statements to do this. 

 

valueexpression=IF({entryDate}<{DE:Original Request Date},WEEKDAYDIFF({entryDate},$$TODAY),IF({DE:Original Request Date}<{entryDate},WEEKDAYDIFF({DE:Original Request Date},$$TODAY)))

 

 

 

 

Kundanism
KundanismAuthor
Level 10
February 17, 2025

Thanks @kelliegardner ,

1) Is it possible to consider only Week days?

2) One additional request, if we want in no. of weeks, how to edit this code?

Please suggest.

Have a nice day!

 

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
February 19, 2025

It should be set to do weekdays utilizing the WEEKDAYDIFF already. 

 

 This formula would calculate the number of whole weeks between dates you could work this into the formula provided. 

 

CEIL(DATEDIFF(Field A,Field B)/7) 

Terms & ConditionsAccessibility statement

Loading footer...