Collections - Shopping - SuperMemo - FAQ - Feedback - Contact us
 Excel XP Functions Date & Time
 Home > Sciences > Computer Science > Excel XP Functions Date & Time
 Report a bug The Contributors` Pantheon | Site map Site index

 Search

 Match: AllAnyBoolean Format: LongShort Sort by: ScoreTimeTitleReverse ScoreReverse TimeReverse Title

Author(s): SuperMemo Library

No. of items: 160
Rating:
Last updated: Jul 31, 2003

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

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

 SM6 SM7 SM8 SM98 SM99 SM2000 SM2002 Palm SM SMCE

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