Excel

I need help to convert a birthday in one format to another w/o using the cell formating by using EXTEXT and DATEDIF.

example: 901101 -> 1990-11-01

  1. 0
  2. 7
asked by Andrew
  1. I used to know how to do this in older versions of Excel, but can't figure it out in the newer version I have now. Sorry, but maybe somebody else does.

    1. 0
    posted by Reed
  2. That is ok. I will figure it out. I appreciate that you are honest with me and that you took time to answer.

    1. 0
    posted by Andrew
  3. I agree with Reed.

    The unfortunate thing is that, as Microsoft and other companies think they are improving things with each new version, they are really making everything more complex and difficult to use. The worst thing I've seen lately is "the ribbon" that MS has put on different Office programs. =(

    1. 0
    posted by Writeacher

Respond to this Question

First Name

Your Response

Similar Questions

  1. java/programming

    ask the user to enter his or her birthday in the MM/DD/YYYY format and output the number of days between the birthday and today. This gives the person's age in days.
  2. Python Programming

    Given a time in the 12 hour format with the suffix, either AM/PM, convert that into a 24 hour format. 12 hour format is hours:minutes:seconds followed by AM or PM, where the hours range is from 0 to 12, minutes range is from 0 to
  3. Math

    Matt got a dollar on his birthday. On his second birthday he will get the amount from last year's birthday plus as many dollars as he is old. How much would he receive on his birthday when 12 if this pattern is used. I came up
  4. math

    Your great uncle gave you $2 on your first birthday, $4 on your 2nd birthday, $8 on your 3rd birthday, and so on. (a) How much money will you receive on your 18th birthday? (b) How much money will you receive on your nth birthday
  5. math

    Your great uncle gave you $2 on your first birthday, $4 on your 2nd birthday, $8 on your 3rd birthday, and so on. (a) How much money will you receive on your 18th birthday? (b) How much money will you receive on your nth birthday
  6. math

    Chris received $1 on his first birthday,$3 on his second birthday,$6 on his third birthday,$10 on his four birthday.How much money will Chris receive on his eighth birthday if the pattern continues?
  7. English

    What is the part of speech of "for my birthday" in each sentence? An adverb phrase or an adjective phrase? Would you check them, please? Can a phrase be either an adjective phrase or an adverbial phrase? Thank you. 1. What do I
  8. history

    What is the best format to use when doing a birthday time line
  9. English

    What did yo do on your last birthday? 1. My family celebrated my birthday with a birthday cake at home. 2. At the birthday party at home, my family celebrated me. 3. My family celebrated my birthday by singing a birthday song for
  10. Today is my.......

    Today is my birthday! I wonder what is my HOROSCOPE SIGN? Is it Capricorn? HAPPY BIRTHDAY KAVERI!!!!!!!! WHEN I SAY HAPPY YOU SAY BIRTHDAY HAPPY BIRTHDAY HAPPY BIRTHDAY HAPPY BIRTHDAY TO YOU , HAPPY BIRTHDAY TO YOU , HAPPY

More Similar Questions