posted by .

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

  • I don't know either. -

    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.

  • Excel -

    That is ok. I will figure it out. I appreciate that you are honest with me and that you took time to answer.

  • Excel -

    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. =(

Respond to this Question

First Name

School Subject

Your Answer

Similar Questions

  1. BCIS

    You need to use the help section in your Excel program (press the F1 key and then use the search feature). If you need additional information about Excel, you can use your textbook or go to http://support.microsoft.com/search/, select …
  2. managerial economics

    my cubic equation is O=C+aL+bL^2+cL3 how can i get the excel to help me to do this equation.I need to do a regression analysis to estimate the firm's short-run production function. see tarha question dated july 2,2007 for all of the …
  3. Excel

    I have an assignment where I have to create a birthday list. One of the tasks is to add a countdown til someone's birthday, I have the formula as: =DAYS360($D$200,I3) However how do I calculate it so if some's birthday past I can recalculate …
  4. math using excel

    how do i use excel to plot a graph then find x from the slope of a line?
  5. computers

    Dear Sir, thanks very much for your the very detail instruction which I am still working on it. I need some help in using Microsoft Excel to format rational number in the form a/b( not in reduced form :eg. 3/6 but Excel will return …
  6. words

    12. You’ve created a pie chart in Excel and placed it in a PowerPoint presentation. When you edit the pie chart in Excel, the pie chart in PowerPoint doesn’t retain the changes you’ve made. This means that the object has been …
  7. microsoft excell 2007

    entering the formula=SUM(C5:C18)is cell C19 will resolve in which of the following?
  8. Excel

    I'm trying to format a database, but I am having this problem- I use the "format as table" feature, but then when I use the drop-down menus that appear, one column will format, but when I go to the next column, the previous change …
  9. english 10

    Which ballad convention does Dudley Randall use in “Ballad of Birmingham”?
  10. Language Arts

    I need some examples of the ACES format. I didn't really understand it and I only need one example. I need the format for a remake of a test question that needed to be done with ACES. Thanks in advance to anyone who helps!

More Similar Questions