Time is Flying By

As you may know, just over 10 days ago I opened the doors to my Using Dates and Times online course. I hope you've taken the opportunity to check it out, as the course provides all the info you need to discover how to slice, dice, and otherwise manipulate dates and times in your workbooks.

This is a low-cost video course that shows you, on-screen, how your data is entered and interpreted by Excel. I demonstrate in a hands-on manner how you can use that knowledge to allow you to work with dates and times just as easily as you would work with any other numeric data in the program.

You can find complete information on the course here:

https://usingoffice.com/dates-and-times/

Please take the opportunity to check it out. I'm only accepting students in this course through this coming Thursday, so you'll want to act quickly so you don't miss out.

I hope you enjoy the tips in this week's issue of ExcelTips.

—Allen
     

ExcelTips (menu) for 12 July 2025

Worksheet tabs
Sheets for Days

Need a quick way to have a worksheet for each day in a month? Here's a macro that makes the worksheet creation a snap.

Read this tip »

 
Excel can calculate at lightening speed
Adding Graphics to a Header or Footer

Excel makes it easy to add graphics to a header or footer, as long as you are using at least Excel 2002. Here's the steps to make it happen.

Read this tip »

 
ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 400 pages of detailed info on how to better use Excel. Learn more about Excel today!

 
Date formulas
Calculating the Day of the Year

Need to know what day of the year a certain date is? You can figure it out easily using the formulas in this tip.

Read this tip »

 
Powerful spreadsheets
Dates with Periods

You may want Excel to format your dates using a pattern it doesn't normally use-such as using periods instead of slashes between the day, month, and year. Here's how you can get the format you want, plus some comments on making that format the default for dates.

Read this tip »

     

Special Note!

I've been publishing ExcelTips for years. Decades, actually. The newsletter you are reading right now is for very old versions of Excel. I still publish it because I know that some people are still using very old versions of Excel. Most people, however, are using newer versions of the program. If you are are using a newer version of Excel (2007, 2010, 2013, 2016, 2019, 2021, or the version in Microsoft 365), then you should seriously consider changing to the version of the newsletter designed for you. You can do so by clicking this link.

Thanks for your support of ExcelTips, and I hope you enjoy whichever version of the newsletter you receive. If you have any questions, just let me know.

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939