Working with Date Functions and Date Formatting in Excel

Опубликовано: 02 Февраль 2011
на канале: Danny Rocks

135,683

199

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 02 Февраль 2011, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 135,683 раз и оно понравилось 199 людям.