Excel Articles
  • Power Excel Book Excerpts
  • MrExcel Seminars
  • MrExcel Message Board
  • MrExcel Store

MORE RESOURCES
FOR MICROSOFT EXCEL

  • Excel VBA Book
  • MrExcel 2022 Boosting Excel
  • Learn Excel from MrExcel

Microsoft MVP

Power Excel from MrExcel


  • Monitor Distant Cells
  • Use Real Dates
  • How Can I Tell If Have Real Dates?
  • Convert Text Dates to Real Dates
  • Format Dates
  • Format Dates As Quarters or Weeks
  • Display Monthly Dates
  • Add a Column to Show Month or Weekday
  • Calculate First of Month
  • Calculate the Last Day of the Month
  • Calculate Invoice Due Dates
  • Calculate Receivable Aging
  • NOW, or TODAY?
  • Find the Last Sunday Of the Month
  • Calculate Work Days
  • Farmers Market
  • Calculate Age in Years, Months, Days
  • Coerce an Array of Dates from 2 Dates
  • Use Real Times
  • Strangeness of Time Formatting
  • Convert Time to Decimal Hours
  • Calculate with Time
  • Enter Minutes and Seconds
  • Convert Text to Time
  • Track Negative Time?
  • Fill Blanks With Value Above
  • See Formulas in Excel 2013
  • Bell Curve in Excel
  • Upper Case in Excel
  • Spell Out Numbers in Excel
  • Macro Code from the Internet Into an Add-In
  • Return Data from a Webservice in Excel 2013
  • SUM(B1:B5) is Better Than =B1+B2+B3+B4+B5
  • Add New Functions to Excel with Fast Excel SpeedTools Extras
  • How to Set up Your Data for Easy Sorting and Subtotals
  • How to Fit a Multiline Heading into One Cell
  • No Tiny Blank Columns Between Columns
  • How to Sort Data
  • Sort Days of the Week
  • Sort a Report into a Custom Sequence

  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10

MrExcel.com & related websites debuted on November 21, 1998.

ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

This site contains affiliate links. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com and ExcelArticles.com running.
You can earn a commission for sales leads that you send to us by joining our affiliate program.

Privacy Policy | Cookies Policy

Do not share my Personal Information.

Excel® is registered trademark of the Microsoft Corporation.
MrExcel® is a registered trademark of Tickling Keys, Inc.

© 1998 - 2023 by MrExcel Publishing. All rights reserved.