# Calculation of days excluding weekends **URL:** \ **Category:** Ask for Help\ **Created:** [February 7, 2024, 12:58pm UTC](https://community.glideapps.com/t/calculation-of-days-excluding-weekends/70578 "2024-02-07T12:58:04Z")\ **Posts on this page:** 1\ **Showing post:** 3
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2024, 1:09pm UTC](https://community.glideapps.com/t/calculation-of-days-excluding-weekends/70578/3 "2024-02-07T13:09:17Z")
@tuzin has a Math column that does this that will make your head explode. See below: > [@date Guide on Dates & Times](https://community.glideapps.com/t/guide-mastering-dates-times/70381/2): > > Thank you for combining all this valuable info into one post! This is also relevant here This math formula adds N business days to a specified date assuming Saturday and Sunday are weekends. This formula will always return a business day and it doesn’t account for public holidays. date+floor(n/5)\*7+mod(n,5)-hour(date)/24-minute(date)/1440-second(date)/86400 + 2\*(max(weekday(date+floor(n/5)\*7+mod(n,5)-hour(date)/24-minute(date)/1440-second(date)/86400)-6,0)) + (max(weekday(date+floor(n/5)\*7+mo… --- _[View the full topic](https://community.glideapps.com/t/calculation-of-days-excluding-weekends/70578)._