Hi all, well I'm truly stuck. It turns out that in the date column of the share_prices worksheet, the cell's format is custom, with dd/mm/yy as its format. I need to calculate the number of days of data for each month of the year, starting from Jan to Dec. I tried the countif function, but I end up with "0" as the result. Does anyone know where I'm going wrong here? If I don't get anywhere with this by tomorrow then I may consider contacting my tutor as I really want to get this done out of the way. Thanks for all your help so far, including this one, and I look forward to hearing from you. ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq