Search

Software

Question

Gravatar
Locked

Excel formula question =LEFT,2 on a DATE

By craig.cude ·
I'm trying to get the left two characters from a date that is showing as 10/01/91,but I keep getting a Julian number of "33" instead of (10). I realize the system is reading the 10/01/91 as Julian 33512 and taking the left two numbers but does anyone know how to make it not read it as a Julian date?

Thanks!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

You can try a couple of things....

by ThumbsUp2 In reply to Excel formula question = ...

All dates are storeed internally as a julian date (number). Consequently, you can't use the LEFT function alone to extract what you're seeing representing that date.

Assuming you have 10/01/91 (MM/DD/YY) in cell A1, you can type:

=LEFT(MONTH(A1),2)

or you can shorten it to

=MONTH(A1)

to get the same thing.

gravatar
Collapse -

Is this for a calculation or display?

by jdclyde In reply to Excel formula question = ...

if display, just go into the display options for date/time and select the desired setting.

If for a calculation, can you give an example of what you are trying to do with the month?

gravatar
Collapse -

Last thought, Craig

by jdclyde In reply to Excel formula question = ...

post what your solution was that worked for you. Others that read this later can benefit from this as well, that way.

Be well.

jd

Back to Software Forum
3 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums