Formula: Max date+holiday

[Nanogirl21]

Is there a way to calulate a DATE+1+HOLIDAY for dates in several columns and return the most recent date from all the columns?

COLUMNS THAT I HAVE DATES IN:
O
S (don't add the 1+HOLIDAY to the dates in this coulmn)
U
AA:AF

 

[DRSteele]

What you've written is nearly incomprehensible. It looks to me that you might be looking for instruction on how to use function NETWORKDAYS, which contemplates holidays in its arguments.

See here https://support.office.com/en-us/ar...pId=xlmain11.chm60520&ui=en-US&rs=en-US&ad=US

 

[Nanogirl21]

What you've written is nearly incomprehensible. It looks to me that you might be looking for instruction on how to use function NETWORKDAYS, which contemplates holidays in its arguments.

See here https://support.office.com/en-us/ar...pId=xlmain11.chm60520&ui=en-US&rs=en-US&ad=US

No, I know how to use network days, but what <g class="gr_ gr_29 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="29" data-gr-id="29">i'm</g> looking to do is return the max (most recent) date in a range that does not already have the holidays <g class="gr_ gr_24 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="24" data-gr-id="24">calulated</g> into them. I'd rather not create 8 new columns to <g class="gr_ gr_25 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="25" data-gr-id="25">calulate</g> the date+1+holiday THEN create another column for a formula to return the max (most recent) date. Is there any way to achieve what <g class="gr_ gr_30 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="30" data-gr-id="30">i'm</g> looking for all in 1 step/formula?

COLUMNS THAT NEED 1+HOLIDAY <g class="gr_ gr_23 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="23" data-gr-id="23">CALULATED</g>
O
U
AA
AB
AC
AD
AE
AF

COLUMN THAT DON'T NEED ANY ADDITIONAL <g class="gr_ gr_22 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="22" data-gr-id="22">CALULATONS</g>
S

 

[DRSteele]

Please provide some sample data together with expected outcomes so that we can conduct experiments and help you on your way.