Do you use Excel spreadsheets to keep track of your weekly, monthly or annual expenses but find yourself updating all relevant date and content information manually? There is an easier, more effective ...

You can manually enter the duration of the task or use one of these Excel formulas to fill in those cells automatically: End date – Start date = Duration End date – Start date + 1 = Duration ...

How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.

To ensure that Excel converts your date to a number enter it like this, without quotes: "4/4/2011". Then click on cell "A2" and enter the later of the two dates in the same manner.

Excel’s Date filters are very comprehensive and allow you to extract individual or multiple dates by day, week, month, year, quarter, or year-to-date, plus dates within ranges.

SEE: Learn how to hide rows and columns and use groups in a shared Excel workbook. How to generate incremental time values using an input cell The above formula works fine if it’s a one-time series.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.