Enter the joining time as the start time, and enter the separation time as the end date. The third parameter takes legal weekends (Saturdays and Sundays) as an example. Refer to the weekend parameter values and description table and enter 1. Finally enter the holiday time and click OK.
Position the cursor at the lower right corner of the cell and pull down to fill the cell in a cross shape to calculate the number of employee working days in batches.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ti-sheng-xiao-lv-yuan-gong-gong-zuo-tian-shu-de-kuai-su-ji-suan-fang-fa.html
支付宝扫一扫 
评论列表（196条）
测试