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
Watch video Working with Date Functions and Date Formatting in Excel online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 02 February 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 135,683 once and liked it 199 people.