Counting Day Type
Header 1 | Header 2 | Header 3 | Header 4 |
---|---|---|---|
Employee Name | Todo Name | Date | Date Type |
xyz | a | 8/02/2014 | working day |
xyz | b | 8/02/2014 | working day |
abc | c | 9/02/2014 | Holiday |
lmn | e | 11/02/2014 | working day |
How can i write formula in crystal report to find no of working day in between 8/02/2014 to 11/02/2014 i.e 2 working day..
Tags:
Abhilash Kumar replied
Please have a look at Ken's website for the formula:
http://www.kenhamady.com/form01.shtml
The Holiday list array formula is here:
http://www.kenhamady.com/form17.shtml
-Abhilash