Learn Excel 2010 – “Previous Work Day?”: Podcast #1421
September 5, 2011 was the ‘Labor Day’ Holiday in the States; Labor Day is celebrated in honor of those workers who have contributed economically and socially…but it can make spreadsheet calculations a little difficult [as can most holidays, weekends, vacation time]. Today, in Episode #1421, Bill shows us how to calculate the previous work day – particularly when that previous day is a holiday. Learn how to work with the =WORKDAY Function, Holidays, Weekends, a few Excel Shortcuts and More when calculating time with Excel.
…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Entry filed under: Excel 2010, Learn Excel 2007 through Excel 2010, Learn Excel 2010, Learn Excel from MrExcel, MrExcel Podcast, MrExcel Products, New MrExcel Publication. Tags: 2010, accounting, Bill Jelen, business, Calculating Days Worked, Calculating Hours Worked, Excel 2010, Functions, Hours worked excluding holidays, Hours worked including holidays, MrExcel, shortcuts, spreadsheets, technology, Time in Excel, tutorial, WEEKDAY, Worksheet.