As you create Excel spreadsheets for your small business, time and date functions frequently add both convenience and programming capability to your workbooks. There's good news with date functions.

How to subtotal transactions by conditional date components in Excel Your email has been sent Image: utah778, Getty Images/iStockphoto Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft ...

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you ...

Managing date lists in Excel can often feel repetitive and time-consuming when done manually. However, Excel provides a range of powerful tools to streamline this process, allowing you to save time ...

Q. When I paste a large amount of data into Excel containing dates as far back as the 1800s, the recent dates display correctly as valid dates, but the older dates automatically convert to text. I ...

Excel considers dates and times as numbers in cells, making calculation difficult. Excel processes 6 AM as "0.25," because it is one quarter of the way through the day. If you need to add a number of ...

Although Google Sheets and Excel Online are two of the best free online spreadsheets editing apps, you may not like certain features of them. For example, the date format. In case you do not want to ...

If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...

Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel. Weekends and holidays are important to most of us. Besides enjoying the ...