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

[Kundanism]

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.

[KellieGardner · Accepted solution]

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]

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]

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)