Skip to the content
STL - Blog
Best in-class training – Be delighted, not just satisfied
  • STL Home
  • Blog home
  • Professional & Management
    • Leadership Development
    • Management Training
    • Professional Development
    • Project Management
    • Sales & Customer Service
    • Soft Skills
  • Application
    • Artificial Intelligence
    • Hints & Tips
    • Microsoft Office
      • Access
      • Copilot
      • Excel
      • Excel Data Visualisation
      • MS Project
      • Office 365
      • Outlook
      • PowerPoint
      • VBA
      • Visio
      • Word
    • Microsoft Office Resources
    • Power BI
  • Misc
    • Infographic
    • Technology
    • Fun
    • Company News
  • About us
  • Contact us
  • Blog search
  • STL Home
  • Blog home
  • Professional & Management
    • Leadership Development
    • Management Training
    • Professional Development
    • Project Management
    • Sales & Customer Service
    • Soft Skills
  • Application
    • Artificial Intelligence
    • Hints & Tips
    • Microsoft Office
      • Access
      • Copilot
      • Excel
      • Excel Data Visualisation
      • MS Project
      • Office 365
      • Outlook
      • PowerPoint
      • VBA
      • Visio
      • Word
    • Microsoft Office Resources
    • Power BI
  • Misc
    • Infographic
    • Technology
    • Fun
    • Company News
  • About us
  • Contact us
  • Blog search

Dates Resources

  • Excel Tips: Calculate the weekday from a date

    Mon 17 Oct 2011

    You can display the weekday for dates stored in Excel.  This is especially useful for checking if due dates fall during the working week.  To do this you need to use the weekday function and custom formatting features of Excel.  The screenshot below are from Excel 2010, but this work in earlier versions too. Ensure […]

  • Excel 2010 Tips Autofill and Dates

    Autofill is a feature which will copy content down a column or accrss a row.  However it also creates sequences, using the same technique, with things that it recognises as being part of a sequence.  One such is dates. Enter the starting date of your sequence in Excel and ensure it is formatted as a […]

  • Excel training:Calculating with Dates

    Thu 6 Oct 2011

    One of the most asked questions during our Excel 2010 Training Courses has to be the subject of calculating with dates. Excel stores dates (and times) as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day (e.g. 31/10/2011 10:00 is stored as 40847.42).This is called a serial date, or serial […]

Blog Categories

Consent preferences

TrustPilot Score

TrustScore 4.9   |   2394 reviews

Trustpilot Testimonials

© 2025 STL – Blog

Powered by WordPress

To the top ↑ Up ↑