+ Reply to Thread
Results 1 to 3 of 3

How do I convert dates into numbers for the use of a graph

  1. 07-07-2008, 02:26 PM #1
    zoolander10
    zoolander10 is offline
    Registered User
    Join Date
    07-07-2008
    Location
    Liverpool
    Posts
    1

    How do I convert dates into numbers for the use of a graph

    I want my graph to recognise Dates as numbers. For instance every column that has a date it would count as 1.

    e.g. 21.12.05
    31.12.05
    04.01.06

    I want the sum to add them together to 3?

    Thanks for your help. I hope I have explained myself clearly?

    Zoo
    Last edited by zoolander10; 07-07-2008 at 02:48 PM. Reason: Inappropriate Title
    Reply With QuoteRegister To Reply
  2. 07-07-2008, 02:27 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcome to the forum.

    Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.
    Reply With QuoteRegister To Reply
  3. 07-07-2008, 03:41 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Are those Excel dates formatted to look like that, or text strings?

    If they're numbers, =COUNTA(A1:A10)

    If they're text, =COUNTA(A1:A10)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1