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?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

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:


or you can shorten it to


to get the same thing.

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?

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.


Related Discussions

Related Forums