Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
CUMPRINC(rate,nper,pv,start_period,end_period,type) [Category:
Financial]*
Returns the cumulative principal paid on a loan between start_period and end_
period. Guru Tip: See the example shown for CUMIPMT, above.
DATE(year,month,day) [Category: Date & Time]
Returns the serial number that represents a particular date. Guru Tip: Say that
you have a date entered in D2. To fi nd the fi rst of that month, use =DATE(YE
AR(D2),MONTH(D2),1). To fi nd the last of the month, use =DATE(YEAR(D2),
MONTH(D2)+1,0). Amazingly, the DATE function has no problem with months
in excess of 12. If you ask for the 45th day of the 17th month of 2009 with
=DATE(2009,17,45), Excel will correctly report June 14, 2010.
DATEDIF(start_date,end_date,unit) [Category: Date & Time]
Calculates the number of days, months, or years between two dates. This
function is provided for compatibility with Lotus 1-2-3. Guru Tip: DATEDIF has
only been documented in Excel 2000. The trick is to fi gure out the proper code
for unit. Column C below shows the valid units for DATEDIF. Using these codes,
you can express an age in years, months, day or years, days, or even decimal
years.
 
Search JabSto ::




Custom Search