Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Analysis ToolPak > Date and Time

 
DATEDIFThe number of units between two dates.
EDATEThe serial number that is a given number of months before or after a date.
EOMONTHThe serial number of the last day of a month before or after a date.
NETWORKDAYSThe number of days between two dates excluding weekends and holidays.
WEEKNUMThe week number in the year for a given date.
WORKDAYThe serial number before or after a given number of days from a given date.
YEARFRACThe number of years as a decimal between two dates.
 

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top