Honestly, you guys suck. What on earth makes you think that this format is in any way useful?!?
October 10, 2012
It is a heinous crime against data.
Anyway, I have spent far to long trying to work out how to convert this to a proper date in excel. Here is my resulting formula, I am fairly sure no one will ever find this, but I have put it out there for all and sundry.
=DATE(RIGHT(E2,4),MONTH(1&LEFT(E2,3)),RIGHT(MID(E2,FIND(" ",E2),3),2))
Enjoy.
stuff and things
because I can
101 in 1001 | My travels | My Photos | My Guestbook | Puppy photos | Our Movies
06 May, 2020
22 May, 2015
Mystery May
As per Multi March last year and this year, here is my list for Mystery May:
M | T | W | T | F | S | S |
1 | 2 | 3 | ||||
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 | 29 | 30 | 31 |
- Take a picture of something you see Challenge #1
- Calendar Colouring Challenge
- Ruby Earth Cache Challenge
- Melbourne
- Perplexed
- Cachers Know Cachers V2
- Final Fantasy VII
- 24,12,18...
- Chirp Chirp
- Bring A Friend & Some H2O
- Sit and Rotate here
- Meet The Simpsons
- The Cupcake Cache
- 1st Bennettswood Scouts
- The State of US
- King Arthur
- Kibbutz
- Melbourne Streetscapes 3: Bellbird
- Yes, but is it Art? VI (Sentinel revisited)
- Ghost who walks
- THE TIME LORD (a challenge cache)
- Crafty Codons
- Q Challenge
- Gorilla, you're a desperado
- The Primary Series
- Sankta Akvo
- Spirit Of Tasmania I
- The Shape of Development
31 March, 2015
Multi March
Here is the rundown from Multi March this year:
M | T | W | T | F | S | S |
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 |
- The Cauldron
- Curing Ruby
- Meander On Milpera
- Avenues, Boulevards & Thoroughfares # 1 (II)
- Rowville POW camp
- Circle of Life
- A Scoria Cone
- noir colline affût
- COR - 10
- Kenny's Hill
- 1st Camberwell Scout Group
- Bent Thomas #2
- Technically Oakleigh
- A perspective of Origin
- Wind, water, earth
- Cricketers Bell
- The Melt’n Pot – Those Magnificent Men #2
- To Learn
- Stoneleigh
- The Avenue of Peace
- In The Performance Of Duty
- Gotta L UV the Cobras
- Our Heroes In The Gardens
- Story of Two Captains
- Merri Minute
- TSS - Barking up the Wrong Tree
- TSS A Stones Throw Away
- H.V. McKAY
- Legends of the Game.
- The Old Water Towers - Revisited
- The Nook
Subscribe to:
Posts (Atom)