Counting Day Type

[Former Member]

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

[abhilash_kumar · Accepted solution]

HI Ajith,

Do you already have a formula that finds out if the day is a Holiday or Not - is Header 4 an actual column that displays 'Holiday' or 'Working Day'?

-Abhilash

[Former Member · Accepted solution]

hi abhilash

Sorry for the misunderstanding. Employee Name,Todo Name,Date,Date Type these are the column name(table header).

no i don't have any formula. 

[abhilash_kumar · Accepted solution]

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

[Former Member]

Thanks Abhilash Kumar