DigDB      Excel Add-ins      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

DigDB offers two ways to convert an area of Date or Time values to Weekday, Year, Month, Quarter, or Hour.

Select a range of cells, convert the cells in-place

  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,

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

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

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

    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,

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

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

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

    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?

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

    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?


Features | Testimonial | Download | Purchase | FAQ | Contact (free forum)

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      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 Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.