TRYING TO TRIM MONTH FROM JULIAN DATE CODE

[Josejose]

Hello,

Whenever i try to trim or copy or save as text a date ieec-02 it gives me part of the number format.
ie 01/12/02 and getting mid(4,2) etc gives me something like 91.
i want to be able to copy out the 12 and the 02.
Any help greatfully accepted.

thanks
Jose

 

[BML]

Excel dates are really numbers that have special formatting applied to them. So the date 12-31-02 is really the number 37,621. In order to get the day, month, or year date numeric values, you have to use the DAY(), MONTH(), and YEAR() functions in Excel.

Hope this helps!

 

[Josejose]

Thank you BML,

Thats exactly what i have need.

Cheers
Jose