Excel 2010 Bible

Chapter 12: Working with Dates and Times 259 New Feature Excel 2010 includes two new worksheet functions related to dates: NETWO ...

Part II: Working with Formulas and Functions 260 The DATEVALUE function converts a text string that looks like a date into a dat ...

Chapter 12: Working with Dates and Times 261 FIGURE 12.4 Using AutoFill to create a series of dates. To generate a series of dat ...

Part II: Working with Formulas and Functions 262 This formula uses text functions (LEFT, MID, and RIGHT) to extract the digits, ...

Chapter 12: Working with Dates and Times 263 Calculating the number of work days between two dates ............................. ...

Part II: Working with Formulas and Functions 264 This formula returns 4 , which means that the seven-day period beginning with J ...

Chapter 12: Working with Dates and Times 265 Calculating the number of years between two dates ................................. ...

Part II: Working with Formulas and Functions 266 Determining the day of the year ............................................... ...

Chapter 12: Working with Dates and Times 267 Here’s the formula modified to use the current date: =DATE(YEAR(TODAY()),12,31)-TOD ...

Part II: Working with Formulas and Functions 268 formula assumes that cell A1 contains a date and cell A2 contains a number betw ...

Chapter 12: Working with Dates and Times 269 Other holidays are defined in terms of a particular occurrence of a particular week ...

Part II: Working with Formulas and Functions 270 Easter ........................................................................ ...

Chapter 12: Working with Dates and Times 271 Thanksgiving Day .................................................................. ...

Part II: Working with Formulas and Functions 272 Determining a date’s quarter .................................................. ...

Chapter 12: Working with Dates and Times 273 Note This formula is updated only when the worksheet is calculated. n Tip To enter ...

Part II: Working with Formulas and Functions 274 Calculating the difference between two times .................................. ...

Chapter 12: Working with Dates and Times 275 Tip Negative times are permitted if the workbook uses the 1904 date system. To swit ...

Part II: Working with Formulas and Functions 276 Figure 12.9 shows another example of a worksheet that manipulates times. This w ...

Chapter 12: Working with Dates and Times 277 This worksheet assumes that hours in excess of 40 hours in a week are considered ov ...

Part II: Working with Formulas and Functions 278 To convert decimal minutes to a time, divide the decimal hours by 1,440 (the nu ...