3 columns of calendar data to make a date in another column

Posted on 2011-10-27
Last Modified: 2012-05-12
i have 3 columns
in column a i have the month
in column b i have the day
in column c i have the year  (only 2 places)

for instance.  
my data
a (month)   b(day)   c(year)     what i am trying to get in one column
     5               24          4               5/24/2004
     11               8         99              11/8/1999

so the third column is tricky.... it only has last 2 digits of the year
Question by:jamesmetcalf74
    LVL 6

    Accepted Solution

    If you have no dates prior to 1901, you could try this:

    Open in new window

    LVL 19

    Expert Comment

    Try this:



    Author Comment

    some of the people that were hired in 1979 are coming back as hired in 2079.

    the year column says 79  but in actuality it was 1979
    the formula comes back with it saying 2079
    its dang close tho
    LVL 19

    Expert Comment

    Have you tried my suggestion at ID:37040054?

    It worked well.


    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now