Good evening,
I am a person with very little experience in Excel. I have the 2010 version at home and the 2016 version at work. I work in a law firm and have to calculate filing deadlines for court materials for court applications. In my specific instance, I need to count business days (Saturday and Sunday are not business days in this example). Holidays are included in the count, but if the deadline falls on a holiday, the deadline becomes the previous business day.
So for example, let’s pretend that my court application is taking place on December 29, 2020. I have to serve opposing counsel with my application materials at least 8 full business days before the hearing. That means there needs to be 8 business days between the hearing date and the date of document service on opposing parties. So the materials have to be served by December 16, 2020.
Another example using a holiday - the court’s copy of the application record needs to filed at least 1 full business day before the hearing, so that would fall on December 25, 2020, which is a holiday, so it would move backward 1 day to December 24 to ensure a full business day between the filing and the court date.
I was trying to use the formula =WORKDAY(start date, days, holidays)-1 . But, I think that this formula excludes holidays that fall within the counted time span, and I only want to exclude a holiday that falls on a deadline. Does anyone know a formula that would work?
I have a spreadsheet that I am working on that would illustrate this better. Is there a way to show it somehow?
I would also like to create a court calculator that would count days, only excluding a weekend day or holiday that a deadline fell on, and would move forward to the next day that was not a holiday or weekend day. Would anyone have a formula for that?
Thanks very much in advance for your kind assistance.
Mary
I am a person with very little experience in Excel. I have the 2010 version at home and the 2016 version at work. I work in a law firm and have to calculate filing deadlines for court materials for court applications. In my specific instance, I need to count business days (Saturday and Sunday are not business days in this example). Holidays are included in the count, but if the deadline falls on a holiday, the deadline becomes the previous business day.
So for example, let’s pretend that my court application is taking place on December 29, 2020. I have to serve opposing counsel with my application materials at least 8 full business days before the hearing. That means there needs to be 8 business days between the hearing date and the date of document service on opposing parties. So the materials have to be served by December 16, 2020.
Another example using a holiday - the court’s copy of the application record needs to filed at least 1 full business day before the hearing, so that would fall on December 25, 2020, which is a holiday, so it would move backward 1 day to December 24 to ensure a full business day between the filing and the court date.
I was trying to use the formula =WORKDAY(start date, days, holidays)-1 . But, I think that this formula excludes holidays that fall within the counted time span, and I only want to exclude a holiday that falls on a deadline. Does anyone know a formula that would work?
I have a spreadsheet that I am working on that would illustrate this better. Is there a way to show it somehow?
I would also like to create a court calculator that would count days, only excluding a weekend day or holiday that a deadline fell on, and would move forward to the next day that was not a holiday or weekend day. Would anyone have a formula for that?
Thanks very much in advance for your kind assistance.
Mary