The war between wetware and hardware.
- Posts: 32802
- Joined: Tue Jun 08, 2004 11:52 pm
- Title: Rhino of the Florida swamp
- Has thanked: 431 times
- Been thanked: 732 times
I am trying to get the year from a column of dates. I am using right(cell,4) and I get odd results
Cell formats are the same.
Is this another example of the paranormal?
- Posts: 70322
- Joined: Mon Jun 07, 2004 1:33 pm
- Title: Yes, that one.
- Location: Chicago
- Has thanked: 3038 times
- Been thanked: 1135 times
Convert the dates to "string" before using the "right" function.
Any man writes a mission statement spends a night in the box.
-- our mission statement plappendale
- Posts: 21939
- Joined: Tue Jun 29, 2004 12:40 am
- Location: New Port Richey, FL
- Has thanked: 354 times
- Been thanked: 373 times
Supposing the dates are in column A and starting with row 2, and your Year formula is in B2:
Copy down. Done.
"If fighting is sure to result in victory, then you must fight! Sun Tzu said that, and I'd say he knows a little bit more about fighting than you do, pal, because he invented it, and then he perfected it so that no living man could best him in the ring of honor. Then, he used his fight money to buy two of every animal on earth, and then he herded them onto a boat, and then he beat the crap out of every single one. And from that day forward any time a bunch of animals are together in one place it's called a zoo! (Beat) Unless it's a farm!"
- Posts: 10271
- Joined: Tue Nov 13, 2007 11:00 pm
- Location: Hangar 18
- Has thanked: 37 times
- Been thanked: 124 times
In excel, what you see is not always the same data format that functions see. If in doubt, cast to another format or use a different function.
It's "pea-can", man.
Lapis Sells . . . But Who's Buying?