[EXCEL] - Creation of a formula for templates with attendance list

Hello

I have a problem, I work on the template as in the attachment, and I would like to add a formula to it in one line that, after entering the date in another line, will determine whether or not a given employee is at work on that day:



I don't quite know how to tackle the topic below is the formula that counts the total number of days in the year of absence:

= SUM OF CONDITIONS (Absence_eventory [Days]; Absence_reading [Employee's first and last name]; Employee_Val; Absence_check [Start Date]; "> =" & DATE (Calendar_year; 1; 1); Absence_of [End Date]; "

Darekstw wrote:

I don't quite know how to tackle the topic below is the formula that counts the total number of days in the year of absence:
= SUM OF CONDITIONS (Absence_eventory [Days]; Absence_reading [Employee's first and last name]; Employee_Val; Absence_check [Start Date]; "> =" & DATE (Calendar_year; 1; 1); Absence_of [End Date]; "

Darekstw wrote:

I act on the template as in the attachment, and I would like to add a formula to it in one line

Your buddy activities with such a spreadsheet should start with "tidying up" it before you start "improving" it

The formulas presented in the attached file (both those in the "first weeks" of the Calendar View and those in the "next weeks") generate for me - Excel 2007 - almost only errors .

I can see that these errors made in Excel 2013 appear in several places, e.g .:
-criterion TEXT (DATE (Calendar_year, ROW ($ A1), 1), "ddd") = LEFT (C $ 5, 5) only coincidentally in a few lines it is true - because you don't know why you made the column headings 2-5 characters against the "ddd" format;
- criterion AK7 + 1