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/**,but I keep getting a Julian number of "33" instead of (10). I realize the system is reading the 10/01/** 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.

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/** (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

Start or search

Related Discussions

Related Forums