Working with Date Functions and Date Formatting in Excel
This video lesson is a response to two YouTube viewers who wanted my help to learn how to use Excel's Date Functions and Excel's Custom Formatting to reveal the results that they were expecting in each cell.
For the first viewer:
I demonstrate how to use the =DATE(Year(), Month()=9, DAY()) Function to create a date that is 9 moths after the starting date.
For my second viewer, I show him how to create and apply a CUSTOM date format of yyyy-mm-dd - (Year, Month, Day) - to the DESTINATION cells when he uses Copy & Paste. This is a two step process as you will see in this video.
Finally, I show you how to take advantage of the NETWORKDAYS() and WORKDAY() Functions in Excel - including an optional list of mandated Holidays in the USA.
Please visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to explore the many resources that I offer you.
Danny Rocks
The Company Rocks
Видео Working with Date Functions and Date Formatting in Excel канала Danny Rocks
For the first viewer:
I demonstrate how to use the =DATE(Year(), Month()=9, DAY()) Function to create a date that is 9 moths after the starting date.
For my second viewer, I show him how to create and apply a CUSTOM date format of yyyy-mm-dd - (Year, Month, Day) - to the DESTINATION cells when he uses Copy & Paste. This is a two step process as you will see in this video.
Finally, I show you how to take advantage of the NETWORKDAYS() and WORKDAY() Functions in Excel - including an optional list of mandated Holidays in the USA.
Please visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my videos and to explore the many resources that I offer you.
Danny Rocks
The Company Rocks
Видео Working with Date Functions and Date Formatting in Excel канала Danny Rocks
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to Use Conditional Formatting in Excel to Highlight Specific CellsWorking with Worksheets in ExcelHow to Examine & Edit the VBA Code for a Recorded Macro4 Steps to Take Before Recording a Macro in ExcelHow to Work with Numeric Values in Excel Pivot TablesHow to Prevent Empty Cells from Displaying in a Pivot TableHow to Use Data Validation When Creating a BudgetHow Excel Stores and Formats DatesEssential Excel Skill #2 - Selecting Cell Ranges EfficientlyEssential Excel Skill #1 - Entering Data Efficiently in ExcelHow to Correct #N/A Error Messages for VLOOKUP Function in ExcelHow to Clear Cell Formatting in ExcelUse Lookup Functions in ExcelUse an Excel Check Box to "Toggle" Conditional Formatting On or OffHow to Use Conditional Formatting in Excel to Highlight Date RangesUsing Subtotals and Pivot Tables - Lesson from My Excel 2010 Video PackageHow to Highlight Different Values in a Row in ExcelHow to Combine 2 Excel Workbooks Using VLOOKUPHow to Use the Histogram Tool in ExcelHow to Use an Array Function in Excel - The Frequency FunctionUse a Pivot Table to Summarize Excel Data By Hours