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
- SuperMemo 
Contact us 
