**These are the some of the criteria my next code will work on:** ( These are those criteria which were unclear until now ! )

Holidays are shown in yellow background color

Normal working days have no background color

The data rows to be considered are those filled with dates in column E

__“TOTAL NO. OF DAYS” ( to be placed by the code in cell C34 )__

For all Months, the “TOTAL NO. OF DAYS” ( to be placed in cell C34 ) **is not** necessarily the number of days worked.

The formula for calculating this is:

_Assuming the employee is not Absent for any day, then the “TOTAL NO. OF DAYS” is always taken as 30

_ If the employee has one or more normal days of absence, ( normal days with no total working hours ), then the formula for calculating “TOTAL NO. OF DAYS” is as follows:

TOTAL NO. OF DAYS = 30 – ( Count of “ABSENT” )

__“ABSENT” ( to be written in some rows in Column K by the program )__

Count of “ABSENT” is the number of occurrences of ABSENT in column K in the final ( After ) Worksheet “ABSENT” is to be written in some rows of column K by the code under certain criteria.

( “ABSENT” **is not** necessarily the normal working days in which an employee is absent and / or has no total working hours. )

“ABSENT” is to be written in column K by the code under the following criteria:

_ For the rows of all normal days when the employee has no working hours, ( days when the employee is absent ), “ABSENT” is to be written in column K.

_ **In addition **, should it occur that an employee is absent for both the days before and after a holiday, then for the ( Holiday ) row in between those two days, “ABSENT” is to be written in column K.

( No consideration of this ““ABSENT” criteria thereof” is made for the case of a Holiday at the first or last “Entries” )

( The number of “Entries” is taken as the filled dates in column E )

__Column L ( help column )__

**Nelson has chosen the second code**. It puts **formulas** in cells C34, G34, and J34.

This requires “H” or “N” to indicate **H**oliday or **N**ormal working day. This will be written by the code in column L

_......................

**Nelson: **

Please examine the above criteria , and tell me if this is correct ?

Alan

## Bookmarks