Excel Semi-Pro
How to Use Microsoft Excel. Learn Online.
The DATEDIF Function comes in handy when you want to know how many years, months, and days there are between two dates. And even though it may be slightly flawed, it still beats the …
Continue Reading about How Many Years, Months and Days Has it Been? →
I've a simple formula for calculating the Xth Weekday of ANY month. It takes four inputs: Year, Month, Week, and Day. And requires a couple of lookup tables for data validation, one with special …
Continue Reading about Calculate the Xth Weekday of Any Month in Excel →
Excel is a great tool for figuring stuff out, like for conversions that aren't easy to do in your head. Here I'm converting Pace to MPH and then reversing the process, converting MPH to Pace, to …
Continue Reading about Convert Pace to MPH and Back Again in Excel →
Converting a decimal time value to minutes and hours is easily done in Excel. That is, if the time value is less than 24 hours. Decimal to Time Conversion Here are three simple steps to convert …
Continue Reading about Convert Decimal Hours to Time in Excel →
Excel 2010 has new return_type arguments for the WEEKDAY Function. How useful they are is debatable, but you never know when you might come across a particular need. Excel Weekday Function The …
The unit of time in Excel is the Day. By using the NOW Function to show both date and time, you can see the underlying serial number by changing the cell format to General. This serial number is …
