• Home
  • About

Entries RSS | Comments RSS
  • Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

  • Categories

  • Archives

  • Recent Posts

    • Create Single Click Desktop Icons
    • Open a Second Window in Outlook 2007
    • Excel Twitters 20090103
    • Excel Twitters 2008127
    • Have an Excellent Christmas!
  • Pages

    • About
  • Subscribe in a reader

Working With Dates In Excel

Posted on November 19th, 2008 by Debra Dalgleish

This week I’ve been working on date formulas, from very simple ones, to complex formulas that calculate workdays per month, based on start and end dates that can span several months.
Extract Information from a Date
Many times I need to pull a bit of information from a date, such as the year, month or weekday.

Here are [...]

Filed under: Excel | 9 Comments »

  • Subscribe

    Subscribe in a reader
  • Email Updates

    Subscribe by Email
  • Calendar

    November 2008
    S M T W T F S
    « Oct   Dec »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    30  
  • Contextures

    • Contextures Excel Pages
    • My Video Tutorials
  • Excel

    • Daily Dose of Excel
    • Excel Team Blog
    • Jan Karel Pieterse
    • JP’s Excel/Outlook
    • PTS Blog
    • Spreadsheet Page Blog
    • TVMCalcs Excel Blog
  • General

    • Hodge Blog
    • J-Walk Blog
    • SuiteMinute