---
title: "Comment by Jared C on \"SQL - Calculating Date Offset While Excluding Weekends\" | Hashnode"
description: "This is great, thank you. Curious if you've figured out how to do this while also excluding Holidays?"
url: "https://hashnode.com/posts/sql-calculating-date-offset-while-excluding-weekends/670e422139c9633aa18c4e24/comment/671667f3e6bb12889eae5ce0"
---

[Discussion](https://hashnode.com/posts/sql-calculating-date-offset-while-excluding-weekends/670e422139c9633aa18c4e24)

Comment [SQL - Calculating Date Offset While Excluding Weekends](https://hashnode.com/posts/sql-calculating-date-offset-while-excluding-weekends/670e422139c9633aa18c4e24)

[Jared C](https://hashnode.com/@jdc136)

[Oct 21, 2024](https://hashnode.com/posts/sql-calculating-date-offset-while-excluding-weekends/670e422139c9633aa18c4e24/comment/671667f3e6bb12889eae5ce0)

This is great, thank you. Curious if you've figured out how to do this while also excluding Holidays?

[Lucas Hirschegger](https://hashnode.com/@lucashir)

[Oct 21, 2024](https://hashnode.com/posts/sql-calculating-date-offset-while-excluding-weekends/670e422139c9633aa18c4e24/comment/671667f3e6bb12889eae5ce0#reply-67168a150034ccf87ab709f4)

Hello Jared, for holidays, I prefer to rely on a web service, I have updated the query.

[Jared C](https://hashnode.com/@jdc136)

[Oct 22, 2024](https://hashnode.com/posts/sql-calculating-date-offset-while-excluding-weekends/670e422139c9633aa18c4e24/comment/671667f3e6bb12889eae5ce0#reply-6717b6a0759c2f5125affac0)

Thank you! [Lucas Hirschegger](https://hashnode.com/@lucashir)
