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
 
Ad

Advertisements

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)
 
Ad

Advertisements

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

Holidays 9
Holiday 1
A Holiday Wish 9
Skip blanks 6
skipping blanks? 3
Skip if empty 0
Skipping Columns/Rows 2
Auto skipping a cell 0

Top