Collections - Shopping Go to another website with more information - SuperMemo Go to another website with more information - FAQ - Feedback - Contact us 
Excel XP Functions Date & Time
Home > Sciences > Computer Science > Excel XP Functions Date & Time
Recent additions
Report a bug The Contributors` Pantheon | Site map Site index
 
 Search
 
Match:
Format:
Sort by:
 
 About
 
Author(s): SuperMemo Library
 
 
No. of items: 160
Rating: 4.5 (out of 5)
Last updated: Jul 31, 2003
 
 
Privacy policy Go to another website with more information
 

Due to SuperMemo Library being moved to a new server, you can currently order this collection only as a subset of one of the mixes from Super Memory Store that are listed in the Order as part of... section you can find in the left pane of this page (if available). We sincerely apologize for any inconvenience this may cause.
Our entire assortment is being republished incrementally in order of priority as determined by the quality and popularity of individual collections. If you would like to increase the priority of this collection, contact us by writing to: publish (at) super-memory (dot) com with in the subject.

 Description
 
Microsoft Excel XP - one of the most popular spreadsheets - provides a number of functions that will help you prepare spreadsheets containing various calculations (from the most simple to the most complex). Among over 220 functions available in standard Excel XP installation, there is a group containing 14 date & time functions that will help you prepare simple and sophisticated formulae.
The collection contains basic information about syntax, usage, and properties of the following Excel XP functions:
  • DATE
  • DATEVALUE
  • DAY
  • DAYS360
  • HOUR
  • MINUTE
  • MONTH
  • NOW
  • SECOND
  • TIME
  • TIMEVALUE
  • TODAY
  • WEEKDAY
  • YEAR
Once you memorize this collection, all above Microsoft Excel XP's date & time functions will no longer be a mystery.
 
 Sample
 
Q: excelXP: For the 1900 date system if year in DATE(year,month,day) function is between [...] and 1899 (inclusive), Excel adds that value to 1900 to calculate the year.
A: 0
A: ex: DATE(108,1,2) returns January 2, 2008 (1900+108)

Q: excelXP: What is the syntax of DATEVALUE function?
A: DATEVALUE(date_text)

Q: excel: When we use the default date system in [...], in DATEVALUE(date_text) function, date_text must represent a date from January 1, 1904, to December 31, 9999.
A: Excel for the Macintosh

Q: excelXP: In DAYS360(start_date,end_date,method) function start_date and end_date should be entered by using the DATE function, or as results of [...].
A: other formulas or functions

Q: excelXP: Is a worksheet updated continuously when NOW() function changes?
A: No (it is updated only when a worksheet is calculated or when a macro that contains the function is run)

Q: excelXP: Any minute value greater than 59, in TIME(hour,minute,second) function, will be converted to [...].
A: hours and minutes
A: ex: TIME(0,750,0) = TIME(12,30,0) = .520833 or 12:30 PM.

Q: excelXP: In TIME(hour,minute,second) function second is a number from 0 to [...] representing the second.
A: 32767

Q: excelXP: What is the syntax of WEEKDAY function?
A: WEEKDAY(serial_number,return_type)

Q: excelXP: The result of YEAR(serial_number) function is returned as an integer in the range [...].
A: 1900-9999

Q: excel: Microsoft Excel for Windows and Excel for the Macintosh use [the same / different] date systems as their defaults.
A: different

 
  Compatibility
 
To use this material you need the SuperMemo software Go to another website with more information. In the table below can you find what versions of SuperMemo the Excel XP Functions Date & Time collection is compatible with

SM6 Go to another website with more information SM7 Go to another website with more information SM8 Go to another website with more information SM98 Go to another website with more information SM99 Go to another website with more information SM2000 Go to another website with more information SM2002 Go to another website with more information Palm SM Go to another website with more information SMCE Go to another website with more information
green check green check green check green check green check green check green check green check green check

 
 Download
 
Download a free sample of all commercial collections available from SuperMemo Library:

Library Digest, (SM2000 format)

 
  Installation HelpDesk
 
The step-by-step procedure with instructions on how to install collections available from SuperMemo Library in:
SuperMemo 6 for DOS
SuperMemo 7 for Windows
SuperMemo 8 for Windows
SuperMemo 98 for Windows
SuperMemo 99 for Windows
SuperMemo 2000 for Windows
SuperMemo for Palm Pilot
SuperMemo for Windows CE
 
 What is SuperMemo?
 
  • SuperMemo makes it possible to learn fast and retain memories for years
  • SuperMemo is based on a breakthrough in scientific research on memory and learning
  • SuperMemo is available as a computer program for Windows
For more information...
 
Send e-mail to a friend
 
Do you have any comments, remarks or suggestions? Contact us
   Back to Top