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.
-- Chris Hallsworth Please visit my blog at http://chrishallsworth.wordpress.com Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected]/ To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/BlindComputing.php If you wish to join the JAWS Users List send a blank email to the following address: [EMAIL PROTECTED]
