Hi fellows,
I am really stuck trying to solve this problem. Any help will be most appreciated.
I have several date ranges that represents employees leave/absence. In order to grant vacations i need to check how many employees are out. So I have a emp...
Do you know by chance if this functions IS_AFTER and IS_BEFORE includes the actual day? The con is that when checking multiple dates i would have to edit the formula and put the dates inside it to filter the results because the airtable doesn´t have ...
In a certain way, but it´s a visual workaround. One had to count matching lines in a given period. This was my first workaround using spreadsheets but it became hard to work with so many records.(in one year i have approximately 700 records).
No, because it has to match more than 2 criterias. See that the first hipothesys has to check all the beginning dates (b) that is before begin and end dates (e) after begin but also end dates (e) after begin and end dates (e) before end. And this con...
