How to calculate length of service| Period of service | Excel tips | Excel learning.
Автор: Office share - Excel learning
Загружено: 2024-05-09
Просмотров: 1292
Описание:
Your boss asked you how to calculate length of service (period of service) of your employees. The datedif function in excel can help you solve this question as soon as possible, you will make a good impression to your boss.
Dateif (start date, end date, "unit")
"Y" The number of complete years in the period.
"M" The number of complete months in the period.
"D" The number of days in the period.
"YM" The difference between the months in start_date and end_date. The days and years of the dates are ignored.
"MD" The difference between the days in start_date and end_date. The months and years of the dates are ignored.
#excel
#ms excel
#microsoft excel
#office office
#ms office
#microsoft office
#excel tips
#excel tricks
#excel tutorial
#how to calculate length of service
#calculate period of service
#calculate working experience
#datedif function
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
