Date spilt into four cells
 

Now I have to go from date into four cells...

I have:
A5: 09/25/04

I need:
D11: 0
E11: 9
G11: 2
H11: 5
J11: 0
K11: 4


My problem:
Instead of pulling the month as 09, it is pulling 38.
09/25/04 = 38255

What I'm using:
=MID($AP$5*100,1,1)+0
Is there a macro or formula to keep the numbers as a date instead o
changing them back to a number

--
hyyft
-----------------------------------------------------------------------
hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318
View this thread: http://www.excelforum.com/showthread.php?threadid=26557

Date spilt into four cells
 

this should help. Gets 09
=LEFT(TEXT(D1,"mm/dd/yy"),2)

--
Don Guillett
SalesAid Software

"hyyfte" wrote in message
...

Now I have to go from date into four cells...

I have:
A5: 09/25/04

I need:
D11: 0
E11: 9
G11: 2
H11: 5
J11: 0
K11: 4


My problem:
Instead of pulling the month as 09, it is pulling 38.
09/25/04 = 38255

What I'm using:
=MID($AP$5*100,1,1)+0
Is there a macro or formula to keep the numbers as a date instead of
changing them back to a number?


--
hyyfte
------------------------------------------------------------------------
hyyfte's Profile:
http://www.excelforum.com/member.php...o&userid=13187
View this thread: http://www.excelforum.com/showthread...hreadid=265575