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.
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:
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel formula question =LEFT,2 on a DATE
Thanks!