Start Free Trial

asked on

Excell date formatting question

Hi guys,

I currently have a row in excel with the data in the following format 9903 (yymm) I need to format this into a date and I can't get it work, I don't see any options in excel with the (yymm) formatting.
My final goal is to convert that date to years to get the age of an account.

Any help will be great!
Thanks.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

whats your expected results?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

my expected result is to format the date that is currently raw 9902 (yymm) to an age, the amount of years from today's date.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

David Johnson, CD

remember that saquib's solution do NOT change the formatting of the column A (do not use custom formatting yymm)