Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

TRYING TO TRIM MONTH FROM JULIAN DATE CODE

Status
Not open for further replies.

Josejose

Structural
Nov 13, 2002
2
GB
Hello,

Whenever i try to trim or copy or save as text a date ie:Dec-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
 
Replies continue below

Recommended for you

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!
 
Thank you BML,

Thats exactly what i have need.

Cheers
Jose
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Top