Mark Holstius![]() Elite ![]() ![]() ![]() ![]() Posts: 744 Joined: 10/11/2012 Location: Sleepy Hollow, IL ![]() | Now that we have export capability (thanks Ed), it may be more accurate to use trading days in many calculations - and this is somewhat difficult in Excel. I’ve put together a SS with 2 tabs that can be copied into any spreadsheet. You can then modify the formulas to find the nearest trading date “on or before” or “after” a date based on Daily, End Of Week, End Of Month, or End Of Quarter. It can also be used to accurately find the # of trading days between 2 dates. The data is accurate from 12/31/1999 thru 12/31/2015 and accounts for all holidays. You just need to “Paste Special Values & Number Formats” all the data from the “Dates” tab starting in cell A1 of a new tab on your spreadsheet also named “Dates”. You can then copy and paste any of the 9 formulas included on the “Lookup Date Example” tab appropriate to your needs and substitute your date cell references in the formulas as necessary. Hope this helps with everyone’s research (to all of our benefit…) Mark [Edited by Mark Holstius on 4/18/2014 12:30 PM] ![]() ![]() ![]() ![]() |