Excel / MS Office Excel – Calculate the number of days in a month January 24, 2015March 7, 2015 Sunil PadmanabhanLeave a comment Use below formula to extract the number of days for a specific month =DAY(DATE(theyear,themonth+1,1)-1) For Example; suppose you require to display number of days for the month of Feb 2014 =DAY(DATE(2014,2+1,1)-1) This equals 28 Share this:TwitterFacebookLike this:Like Loading... Related