Excell formula problem

Discussion in 'Software' started by davidmarley, Jan 12, 2010.

  1. davidmarley

    davidmarley Private E-2

    Can anybody help me with this problem please,

    I need to make the dates below come up in a seperat cell as a number, etc.
    I am using the date format below, I have tried using the IF statement with no success.

    Tue-12-1-10 = 1
    Wed-13-1-10 = 2
    Thu-14-1-09 = 3
    Fri-15-1-09 = 4

    Many Thanks
     
  2. born2golf

    born2golf Private E-2

    Thu 14-1-09 does not = 3
    Fri 15-1-09 does not = 4
     
  3. davidmarley

    davidmarley Private E-2

    I know the above dates don't equal 3 or 4 but that what I want to make them

    Many Thank for your time
     
  4. born2golf

    born2golf Private E-2

    Just at a glance, what if you keep -1-10 to all of them as you progress down?
    11 is a prime number you use in excel.
     
  5. da.bell

    da.bell Private First Class

    Will the next date be 5 then the next one after that be six?

    If that is the case, you might want to count the number of dates from the next cell up to the top of the date column.
     
  6. jewlzs

    jewlzs Corporal

    Excel can not convert text to a number because it is not in an acceptable format for a number constant / incorrect argument.
    text to number format

    When text is expected, numbers and logical values are converted to text

    ="*"&TRUE it will produce A=TRUE

    =Mon&1 should produce 1

    When text is in quotes it will be included in the value ="Mon"&1 you would get Mon=1
    I think if you play with it a little it will work
     
    Last edited: Jan 16, 2010

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds