Hi, thanks for the help, greatly appreciated. I'll give this a try, but I'm not sure what results may come out. Thanks again, and take care.
-- Chris Hallsworth Please visit my blog at http://chrishallsworth.wordpress.com You wrote: Hi Chris, Have you considered using the date function? For example: =date(108,7,7) The 108 represents the year 2008. I found that trying to calculate numbers of days between dates only works with the date function. After you set up the date, you can format it as mm.dd.yyyy or any other format that you want to display the date on the spread sheet. Using the typical date entry such as 7/7 with will give you something like this in the unformatted display: 7-Jul. Entering the date this way I don't think that you can calculate the number of days between dates. HTH, Lennie At 01:47 PM 7/7/2008, you wrote: >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] 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] 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]
