Counting field over Four Date columns if the field has value in the four coloumns


Hello There I have Field which states the Case ID whether its ACTIVE , RESOLVED, PENDING or CLOSED I need to count each case ID over four fields for OPENDATE, CLOSEDDATE, RESOLVED_DATE...etc if any case have the four dates it will be counted over them all
How can I do that ??

Tags (1)
0 Karma