Home > Excel Help Portal > Dates and Times in Excel

<<  (Page 2)  Previous              Next  (Page 1)  >>

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.

101. 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

 
102. 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

 
103. 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

 

<< (Page 2)  Previous              Next  (Page 1) >>