American Dates

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.

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

1. Take a picture of something you see Challenge #1
2. Calendar Colouring Challenge
3. Ruby Earth Cache Challenge
4. Melbourne
5. Perplexed
6. Cachers Know Cachers V2
7. Final Fantasy VII
8. 24,12,18...
9. Chirp Chirp
10. Bring A Friend & Some H2O
11. Sit and Rotate here
12. Meet The Simpsons
13. The Cupcake Cache
14.  1st Bennettswood Scouts
15. The State of US
16. King Arthur
17. Kibbutz
18. Melbourne Streetscapes 3: Bellbird
19. Yes, but is it Art? VI (Sentinel revisited)
20. Ghost who walks
21. THE TIME LORD (a challenge cache)
22. Crafty Codons
23. Q Challenge
24. Gorilla, you're a desperado
25. The Primary Series
26.  Sankta Akvo
27.  Spirit Of Tasmania I
28. The Shape of Development
29. 
30. 
31. 

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

1. The Cauldron
2. Curing Ruby
3. Meander On Milpera
4. Avenues, Boulevards & Thoroughfares # 1 (II)
5. Rowville POW camp
6. Circle of Life
7. A Scoria Cone
8. noir colline affût
9. COR - 10
10. Kenny's Hill
11. 1st Camberwell Scout Group
12. Bent Thomas #2
13. Technically Oakleigh
14. A perspective of Origin
15. Wind, water, earth
16. Cricketers Bell
17. The Melt’n Pot – Those Magnificent Men #2
18. To Learn
19. Stoneleigh
20. The Avenue of Peace
21. In The Performance Of Duty
22. Gotta L UV the Cobras
23. Our Heroes In The Gardens
24. Story of Two Captains
25. Merri Minute
26. TSS - Barking up the Wrong Tree
27. TSS A Stones Throw Away
28. H.V. McKAY
29. Legends of the Game.
30. The Old Water Towers - Revisited
31. The Nook