DigDB           Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

---

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact

Convert Excel Dates to Weekday, Year, Month, Quarter, Hour

Practice file - convert-date-demo.xls (16k)
• Select a range of cells, convert the cells in-place
• Select a single cell in a Table's column, convert the column by inserting a new column

1. Select a range. Only the cells that are date or time values will be converted.
2. Invoke 'DigDB->Selected Area->Convert->Date to->Weekday' for example,

   

3. Result is: (cells are converted in-place)

   

   Converting date/time to Month, Year, Quarter, Hour is the same.

Convert an entire column in a table

1. Select a single cell in a Table's column. The entire column will be converted, with the converted values stored in a new column inserted next to the original column.
2. Invoke 'DigDB->Column->Convert->Date to->Month' for example,

   

3. Result is: (a new column is inserted to store the converted values)

   

   Converting date/time to Weekday, Year, Quarter, Hour is the same.

Converting date column + roll-up (pivot table, subtotal)

Suppose we have a sales records data list like the following. There is only a Date column in the list. How do we do roll-ups (pivot table, or subtotal) to summarize, for example, the sales by Year, Month, Quarter, Weekday?



We can simply convert the 'Date' column to Year, Month, Quarter, Weekday, Hour. Then we will have new columns that are the corresponding Year, Month, Quarter, Weekday, Hour. Then we can do the roll-up, pivot table, subtotal as usual.

For demo on roll-ups, go here.

Need more?

• Browse the complete list of DigDB's powerful features listed on the front page.
• If you see errors or things not working, check out our error reference page.

---

Features | Testimonial | Download | Purchase | FAQ | Contact

Copyright © 1999-2007 All rights reserved

DigDB           Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.