Counting Day Type

This question is answered

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..

Correct Answer

January 22, 2015 at 13:02 PM

Please have a look at Ken's website for the formula:

The Holiday list array formula is here:

-Abhilash

1 Likes 1 View this answer in context

Helpful Answer