This is a discussion on NYSE Trading Days within the Excel Questions forums, part of the Question Forums category; Is there away that a spread sheet can be made to figure out what days of the year and for Become a Registered Member free to remove the ad that appears in the top post.

WORKDAY function - Office Support

Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search. Forum Question Forums Excel Questions NYSE Trading Days. Results 1 to 8 of 8. NYSE Trading Days This is a discussion on NYSE Trading Days within the Excel Questions forums, part of the Question Forums category; Is there away that a spread sheet can be made to figure out what days of the year and for Add Thread to del.

NYSE Trading Days googletag. Is there away that a spread sheet can be made to figure out what days of the year and for the month are trading days?

I would also want the trading days to be numbered 1, 2, 3, There maybe a worksheet alread made to do this but I haven't been able to find one. Thanks for you help. Share Share this post on Digg Del. NYSE Trading Days To explain a little further I want the worksheet to look something like this: Example; Column A Column B Column C all are the same row 4 Date: Day of week TD of week April 1, Thursday 1 April 2, Friday 2 April 5, Monday 3 April 6, Tuesday 4 Charlie.

Last edited by coliervile; Mar 30th, at NYSE Trading Days Hi Charlie You can start by using the function WORKDAY to decide what days are working days..

Then you should be able to derive the other information you need from that result. NYSE Trading Days Thanks WaterGypsy and barry houdini I will give it a go and see what I come up with.

How to Generate a List of Business Days in Excel - dummies

Z10 is January 1, January 18, January 18, April 2, May 31, July 5, September 6, November 25, December 25, Charlie. NYSE Trading Days You will need to make sure you have the analysis toolpak installed.

In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK. If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.

Always make a back up copy before trying new code, you never know what you might lose! Not because of the violence of bad people, but because of the silence of good people!

Thank you schielrn that worked great! Share it with others Like this thread?

Share it with others Twitter Linked In Google Reddit StumbleUpon. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top. All times are GMT The time now is All contents Copyright by MrExcel Consulting.