Hello everybody,
Could you help me in my question,please?
Explaining the file:
-The file contains dates of leaves for employees.
-The dates are written in format of "00" like "01+02"
CountErrors UDF is used to count errors:
1-count duplicate dates for each employee
2-Check for format:counts the error in the format of dates, like "1,2,3", they should be written like this "01+02+03"
3-Can only contain a slash if it's in "substitution" or "of" columns
4-Why get permission if you have balance on your leave?
My question:
I need the UDF to count an extra error:
In "substitution" and "of" columns,if the date contains a "/" , date format(before and after the slash) should be "0" not "00"
For example:
Wrong >>>>> TRUE
06/2 >>>>> 6/2
10/02 >>>>> 10/2
07/01 >>>>> 7/1
See the attachement
Bookmarks