Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
I have an Excel workbook that is used in two different regions where the date format is entirely different, the US and the UK. At the top of a report worksheet I use a TEXT function to inform the user …
Continue Reading about International Short Date Formatting for the TEXT Function →
I recently returned from two weeks in Ireland where I installed a couple of Excel reporting systems and came across the dreaded regional date settings. My computer is set for the US region, whereas …
An associate of mine "helped" me out once by putting a worksheet together for data entry. After the worksheet had several days of user input, I found out the workbook was created on a Mac with an …
Continue Reading about Quickly Adjust 1904 Dates for the 1900 Date System in Excel →
I use the Woopra desktop app to view live visitors to this WordPress blog. Visitors will see a Woopra window lurking about when I'm logged into my (free) Woopra account. One option is to initiate a …
In a previous post I went on and on about how you can calculate hours between two different dates and times, but Excel does this for you automatically. I'll use reader comment as my …
Continue Reading about Let Excel Convert Hours Between Two Dates and Times →
Given the Date in this spreadsheet, a simple formula using the DATE Function will return the Day of Year. Go ahead and type a Date value in cell A2 to see how the formula works, the spreadsheet is …
