Home > Excel Help Portal > Dates and Times in Excel

# Dates and Times in Excel

## The ExcelUser portal offers links to help pages created by top Excel web sites. This section discusses calculating dates and times in Excel.

1. Bond Maturity Value of Securities maturing less than 1 year. Value of Securities maturing 1 - 2 years Value of Securities Matruing 2 - 5 years etc. ABC SecurityValueMaturity Security A Less than 1 =SUM(IF(C2:C6 1-2 years =SUM(IF(C2:C6TODAY()+365,IF(C2:C6 2-5 years =SUM(IF(C2:C6=TODAY()+730,B2:B6,0))... Keywords: Days, Years, Arrays, Formulas, Links, VBA, TODAY

2.
3. Excel FAQ Answers to Frequently Asked Questions about Microsoft Excel Collected by Harald Staff, Microsoft Excel MVP Table of Contents The Excel Application and Excel Files Worksheet Functions and Formats Dates and Times Macros, VBA Functions I didn't find my answer here, now what? Good Resources on the Web... Keywords: Dates, VBA, Files, Web

4.
5. Calculate the number of days in a month Excel lacks a function for calculating the number of days in a particular month, so you'll need to construct your own formula. If cell A1 contains a date, this formula will return the number of days in the month:... Keywords: Charts, Days, Format, Formulas, Printing

6.
 Excel User's Home ExcelUser Blog Site Map Contact Excel for Business Excel Dashboards Excel Solutions Exploring Excel BI for Excel Business Tools Excel Catalog Affiliate Program Excel Help Portal

ExcelUser, Inc.
http://www.ExcelUser.com