43 Folders

Back to Work

Merlin’s weekly podcast with Dan Benjamin. We talk about creativity, independence, and making things you love.

Join us via RSS, iTunes, or at 5by5.tv.

”What’s 43 Folders?”
43Folders.com is Merlin Mann’s website about finding the time and attention to do your best creative work.

Question for the Excel experts....

jasonechols | Sep 21 2006

A co-worker and I were having an interesting discussion this morning about a problem she was having. When she copied dates in Excel, it would add 4 years to her date. After a little research, I discovered that there is a check box under Tools>Options>Calculations...it says "1904 date system".

Can anyone tell me what function this would have?

Why would someone want to use a "1904 date system"?

‹ New effective instrument for Time and Project management. crosspost from the OSX subforum: Moleskine/kGTD icons ›
1 Comment
POSTED IN:
  • 4790 reads
TOPICS: Windows
jason.mcbrayer's picture

Google is your friend. ...

Submitted by jason.mcbrayer on September 21, 2006 - 9:03am.

Google is your friend. It's just another bizarre case of Microsoft prioritizing backward-compatibility over usability, correctness, or even sanity.

» POSTED IN:
 
EXPLORE 43Folders THE GOOD STUFF

Popular
Today

Popular
Classics

Oldies but goldies

An Oblique Strategy:
Honor thy error as a hidden intention

STAY IN THE LOOP:

Subscribe with Google Reader

Subscribe on Netvibes

Add to Technorati Favorites

Subscribe on Pageflakes

Add RSS feed

The Podcast Feed

Cranking

Merlin used to crank. He’s not cranking any more.

This is an essay about family, priorities, and Shakey’s Pizza, and it’s probably the best thing he’s written. »

Scared Shitless

Merlin’s scared. You’re scared. Everybody is scared.

This is the video of Merlin’s keynote at Webstock 2011. The one where he cried. You should watch it. »