| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LEFT function not working with dates
Hello dear Excel friends,
I am trying to build a forumula to get the result "Jul-12" from the given value "Jul-11" This is what i tried and I was getting a result "407-12" not sure if this is a formating issue Date Jul-11 =LEFT(A2,3),"-","12" I know I am wrong. Please help correct me. Thanks Excel Dumbo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LEFT function-all to left of a comma? | Excel Worksheet Functions | |||
| Up,Down,Left,Right stopped working | Excel Discussion (Misc queries) | |||
| Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming | |||
| Sort Left to Right not working | Excel Discussion (Misc queries) | |||
| Left and Right function is not working | Excel Programming | |||
Threaded Mode
