Skip Holidays

A

any

I want to calculate the settlement date(SD) base on the trade date (TD).
Normanly the SD is TD +3 business days. (Skip weekends and holidays)

I set up this calculation:
=IF(OR(WEEKDAY(B341)=2,WEEKDAY(B341)=3),B341+3,B341+5)
This works fine until there is a holiday ( eg. 7/4 and Thanksgiving) in the
period.
Any suggestons?
Thank you.

Iolani
 
C

Chip Pearson

Iolani,

See the NETWORKDAYS function. It will do exactly what you want.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
C

Chip Pearson

Sorry, I mean the WORKDAY function, not NETWORKDAYS.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for total days, excluding holidays but including weekends 3
Adding days to the WORKDAY function 1
Xiaomi Redmi Note 10 Pro?? Do or die? 11
Omiting Weekend/Holidays Dates Problem 7
Workday fxn not recognizing Sat/Sun/Holiday start 2
Date Calculation problem 3
business days - trade date plus 3 2
if statements returning dates 4

Top