Want to calculate using only a certain section of a cell

[demasigirl]

Hello,

I process excel spreadsheets at work that contains a column of numbers which are made up by different parts. Here is an example:

1136556709

"11" represents the year 2011

"365" represents the day of the year. 001 being Jan 01 and 365 being Dec 31.

"56709" represent the number of transactions made on that day.

Is there a formula that will only take the "365" part of the cell and ignore the rest of the numbers?

I'm trying to translate that number into the actual date it represents. I already figured out a formula that takes the 365 number and calculate it into Dec 31 but those other pesky numbers are getting in the way.

[Haseeb Avarakkan]

Assume the date always be in 000 format. Say below 100 will be like for Jan 1 - 11001, For Apr 9 - 11099 etc..

So try this.

=DATE("20"&LEFT(A1,2),1,MID(A1,3,3))