Help with formulas.
How can I add only working days to a date (excluding Saturday and Sunday)?
Hi,
We currently don’t have a formula for working days. A work around is that you create a table that contains all the days of the year and mark Saturdays and Sundays as non-working days. You can reference that table in other fields.
We actually already have such a table in the template OOO Management // Baserow (table OOO Calendar). It also takes public holidays into account.
Hey @alexheiki, we’ll also add a workday function to the Baserow formula field. Thanks for pointing our attention to this.
Do you have any news about this? Will it use public holidays as well (per country?)?
Actually you can easily check about week ends with such a formula :
date_diff(‘day’, field(‘Date begin’), field(‘Date end’)) - (floor(date_diff(‘day’, field(‘Date begin’), field(‘Date end’)) / 7) * 2) - if(datetime_format(field(‘Date begin’),‘D’) = 7, 1, 0) - if(datetime_format(field(‘Date end’),‘D’) = 1, 1, 0)- if(datetime_format(field(‘Date begin’),‘D’) = 1, 1, 0) - if(datetime_format(field(‘Date end’),‘D’) = 7, 1, 0)+1
but it do not take into account public hollidays.
Hey @Thierry, no news, unfortunately. It’s on the list but not a high priority one, so I can’t say when we will pick it up. 