Tag Archives: Dates

There’s history and history!

Posted on 22 October 2013 by spreadsheetexpertblog

The other day I saw an article on the web by a writer who seemed to think that VLOOKUP was new to Excel 2013. Strange, I thought: I was using it in Lotus 123 in 1990. Now that is only … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Automatic Date and Time in Excel

Posted on 17 August 2013 by spreadsheetexpertblog

If you want to put today’s date into your spreadsheet, then use =today(). But remember this is dynamic, which means it will change. Thus it’s not much use for dating a document, because tomorrow’s another day! To get the current … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Date formats – don’t waste valuable information!

Posted on 28 July 2013 by spreadsheetexpertblog

Don’t enter dates with full stops (eg 10.11.13) because Excel doesn’t store them as dates, meaning a lot of useful information is unavailable. Instead, use a slash (eg 10/11/13) or hyphen (10-11-13) when you enter dates. Excel then stores them … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment