# How many trading days are there in 2014?

I could see the list of holidays in NSE site, but is there any way to calculate total of trading days in excel?http://www.nseindia.com/global/content/market_timings_holidays/market_timings_holidays.htm

Not sure about the exact number of trading days in 2014, but in general there are roughly 252 or 254 trading days in any given year.

1 Like

There are many methods to find out, quickly i could think only of this one

243 Trading days for Equity, This is not including any mock trading in real NSE conducts. This is considering only regular trading days.

=((DATEVALUE(“12/31/2014”)-DATEVALUE(“01/01/2014”)-D1-E1+1)/7*5)+(7-WEEKDAY(DATEVALUE(“01/01/2014”)))+(WEEKDAY(DATEVALUE(“12/31/2014”))-1)-18

The last 18 is the number of holidays in 2014 as shown in the NSE website

http://www.nseindia.com/global/content/market_timings_holidays/market_timings_holidays.htm

If you change the year to 2015 you will get for next year and so on.

Why do you want to caclculate this in excel?

On an approximate (52 weeks in a year x 5 equity trading tradings) - 18 number of holidays

(52 x 5) - 18 = 242 will give you a rough estimate, Wont it?