Legal Dates Calculation?

[KZ303]

I'm using Excel to calculate dates in a legal setting, but can't figure out how to: 1) Calculate 1 month or 1 year from now, while 2) NOT returning holidays or weekends. I need to push the date forward one day in those instances, so: If one month from now = Sunday, the result should go to Monday, unless Monday is a holiday, in which case, it needs to show Tuesday.

I have it figured out for weeks/days out, but just can't figure out how to get the right results for months/years out.

Showing my Work:
This is the best I've come up with for months/years, but I haven't figured out how to exclude holidays or weekdays from the results: =EDATE(B3,3) [B3 = the present date, 3 is the number of months I'm adding.]


This formula works great for weeks/days: =WORKDAY(B1+(7-1),1,holidays) [B1 = the present date, 7 days added, excluding holidays in the results.]


Any help is greatly appreciated!

 

[gaz_chops]

Have you tried
=WORKDAY.INTL()

 

[shg]

Welcome to the board.

=WORKDAY(EDATE(A1,1) - 1, 1, Holidays)

 

[KZ303]

I have not, will experiment. Thanks!

 

[KZ303]

Welcome to the board.

=WORKDAY(EDATE(A1,1) - 1, 1, Holidays)

Thanks! That worked awesome for months. I'm tinkering with years, do you know how that would work?

 

[barry houdini]

For years just use multiples of 12 in the same formula, e.g. 5 years

=WORKDAY(EDATE(A1,5*12) - 1, 1, Holidays)

 

[KZ303]

For years just use multiples of 12 in the same formula, e.g. 5 years

=WORKDAY(EDATE(A1,5*12) - 1, 1, Holidays)

Barry, that was perfect. Thanks all for helping! Problem, totally solved!