[access-uk] More Help with Assignment (continued)

  • From: Chris <christopherhallsworth71@xxxxxxxxxxxxxx>
  • To: access-uk@xxxxxxxxxxxxx
  • Date: Mon, 7 Jul 2008 18:45:49 +0100

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

Other related posts:

  • » [access-uk] More Help with Assignment (continued)