Learn how to manipulate dates with the important date functions in Excel

Описание к видео Learn how to manipulate dates with the important date functions in Excel

Topics Covered:
1. Understanding the Magical Date Formats (ex. dddd-dd-mmmmm-yyy)
2. Calculate Total Working Days in any project by two ways:
a. Using NETWORKDAYS Formula (applicable in most cases)
b. A combination of WEEKDAY, IF & SUM (applicable in all cases)
3. Find the First/Last Date // Combine Dates to Months (Twist the EOMONTH function as per requirement)
4. Aggregate Dates into Weeks (WEEKNUM function with Formula Bar and Custom Format)

Комментарии

Информация по комментариям в разработке