Today Xiaobian teaches you to set a formula to calculate 158 days after the new maternity leave, which day is the date of the end of the holiday, now we open EXCEL, practice it together.
Lenovo Yangtian M2612d
Windows7 version 6.1
Office Excel2013
Related content Illegal climbing taken from experience
If there is a summer vacation and a winter vacation, enter the following headings in the first line respectively: Leave date, Summer Vacation Start time, Summer Vacation End time, Summer vacation Total time, Winter Vacation Start time, Winter vacation end time, Winter vacation Total time, maternity leave end date.
Calculate the total summer vacation time at D2: =IF(B2= ", "",C2-B2).
Enter the formula in cell E2 to calculate the total winter break time: =IF(E2= ", "",F2-E2).
Time: the end of the H2 calculation maternity leave = the IF (A2B2 A2B2, A2 < C2, A2 + 158 + (C2 - A2) < F2), A2 + 158 + (C2 - A2) + G2, "))).
I hope it helps.