Job Recruitment Website - Job seeking and recruitment - Excel recruitment cycle function formula
Excel recruitment cycle function formula
In the first line of column A (A 1), enter the requirement submission time.
In the first row of column B (B 1), enter: suggested recovery time.
Enter the interview time (C 1) in the first row of column C.
Input by analogy: interview passing time, arrival time, department delay time, candidate delay time and recruitment cycle.
Enter the corresponding data in the second line (for example: 20 12123 February 20126 February 2012/3 February 2012).
Enter the formula =MAX (network days (B2, C2)-4,0) in F2.
Enter the formula =MAX (network days (D2, E2)-8,0) in G2.
Enter the formula in H2: = network days (A2, E2)-F2-G2.
As shown in the figure:
- Previous article:Is Zhongshan Sanxin Primary School easy to enter?
- Next article:Can I hang a recruitment banner in the village?
- Related articles
- When will Anqing Haikou Bridge start?
- How about Dongguan Jiali Catering Management Co., Ltd.?
- Does anyone know the address and phone number of PetroChina and Sinopec in Dazhou, Sichuan? It would be best to have a contact person~Thank you
- Lijiang scenic spots are open to all medical staff free of charge
- What if Handan ktv doesn't let the accompaniment sing?
- Does the institution recruit every year? How many months does the institution go out every year?
- How about Hong Kong Garden? OK? Is it worth buying?
- Where is the best dyeing place for Harbin mink?
- Is there any preparation for the open recruitment of preschool teachers in 2022 compulsory education schools in Anlu City?
- Do you need to work night shift at Dongying Airport?