posted by Andrew

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. Reed

    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.

  2. Andrew

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

  3. Writeacher

    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

Your Answer

Similar Questions

  1. 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 …
  2. 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 …
  3. Excel

    The use of excel Excel is a very necessary tool for all businesses in today's job market. Excel makes it easy to organize, calculate, analyze and chart data. It can be used for both simple and concrete projects. Excels spreadsheets …
  4. Computer - Excel Mail Merge

    I have a problem when doing the mail merge with Office 2003. First of all, I wrote a letter in Word 2003 and then try to merge some data from Excel 2003. The data in Excel column was listed as below: A1=101 A2=123 A3=134 A4=148A A5=181B …
  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. 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.
  7. excel graphing

    In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18-E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to the …
  8. Excel formula help

    Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10 I don't understand cell z2 through z10 I have never had excel (4kxz2xz10) Please write this correctly
  9. Excel

    I have my employee schedule in a excel sheet. It is a weekly schedule that doesn't change week by week, but changes day by day within a week. Every Monday, Tuesday, etc. is the same schedule. In the file are days for Monday, Tuesday, …
  10. 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 …

More Similar Questions