Software

Ask something
Question Locked

Excel formula question =LEFT,2 on a DATE

0 helpful
4 replies

by craig.cude

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

4 replies

by thumbsup2

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.

by jdclyde

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?

by jdclyde

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

This discussion is closed to new replies.