chapter 7

DAYS function

=DAYS(end date,start date)

YEARFRAC function

Calculates the fraction of a year between two dates based on the number of whole days. =YEARFRAC(start date, end date)

DAY function

DAY (serial_number) - returns the day portion of a date (a number between 1 and 31)

MONTH function

MONTH (serial_number) - returns the month portion of a date (a number between 1 and 12)

WEEKDAY function

WEEKDAY (serial_number, [return_type]) - returns the day of the week

YEAR function

YEAR (serial_number) - returns the year portion of a date (a number between 1900 and 9999)

who uses the day, year, weekday functions?

banks and credit card companies

IFS function

evaluates multiple conditions and returns a result that corresponds to the first true condition

dates

excel displays dates differently than it stores dates

AND function

has two or more logical tests and returns true only if all conditions are true or FALSE if any of the conditions are false

Switch function

logical function that evaluates an expression, compares it with a list of values, and returns the first corresponding result =SWITCH(expression, value1, result1, [default or value 2, result 2])

what is january 1, 1900

1