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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.