Hi,
I have a data pull that gives me current month historical records. The data
received will always be yesterday going back by day to the beginning of the
current month. So, today's data would be from yesterday to the first. The
date pulled comes to me in the following format
01€*
02€*
03€*
04€*
05€*
06€*
07€*
08€*
09€*
10€*
11€*
12€*
This refers to the day of the current month. I would like ideas how I might
convert this to display as a regular date format in another cell (beside it)
mm/dd/yyyy
Each day the list increases by one number, at the bottom of the list.
Does anyone have any suggestions?
--
Mike Thran

Try this:

=DATE(YEAR(TODAY()),MONTH(TODAY()),LEFT(A1,2))

Format the cell as mm/dd/yyy, and copy down as required.

Hope this helps.

Pete

On Aug 13, 4:28Â*pm, M Thran . wrote:
Hi,
I have a data pull that gives me current month historical records. The data
received will always be yesterday going back by day to the beginning of the
current month. So, today's data would be from yesterday to the first. The
date pulled comes to me in the following format
01€*
02€*
03€*
04€*
05€*
06€*
07€*
08€*
09€*
10€*
11€*
12€*
This refers to the day of the current month. I would like ideas how I might
convert this to display as a regular date format in another cell (beside it)
mm/dd/yyyy
Each day the list increases by one number, at the bottom of the list.
Does anyone have any suggestions?
--
Mike Thran