Tag Archives: dates

Dealing with dates -1, date values and formats

Following a discussion at Eng-Tips, I have been having a closer look at how Excel handles the entry and display of dates.  The Eng-Tips discussion concerned changes to data when csv files are opened in Excel.  I will deal with that (together with … Continue reading

Posted in Excel | Tagged , , , , , | 4 Comments


It has just come to my notice that this year I missed my half millionth Birthhour, which was also my 30 millionth Birthminute. Luckily I still have plenty of time to prepare for my 2 billionth Birthsecond. To avoid missing … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , | 3 Comments