aliaslamy2k
Active Member
- Joined
- Sep 15, 2009
- Messages
- 416
- Office Version
- 2019
- Platform
- Windows
Hello,
How Can I avoid this number “-43735, -43689 “, I am subtracting date from date. If any cell is blank then the result should come as blank.
Thank you
How Can I avoid this number “-43735, -43689 “, I am subtracting date from date. If any cell is blank then the result should come as blank.
Thank you
Recruitment Dashboard - Ali - 3 - Live V0.01.xlsx | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
13 | Process | Dates | Days | Days from App rcvd | ||
14 | ERF RECEIVED DATE | 05-Aug-2019 | ||||
15 | APPLICATION RCVD DT | 12-Aug-2019 | 7 | |||
16 | PHONE INT BY HR | 15-Aug-2019 | 3 | 3 | ||
17 | FWD TO BUSINESS | 17-Sep-2019 | 33 | 36 | ||
18 | RPLY RCVD FRM BSNESS | 19-Sep-2019 | 2 | 38 | ||
19 | TEL INT BY BSNESS | 25-Sep-2019 | 6 | 44 | ||
20 | FEEDBCK FRM BSNESS | 27-Sep-2019 | 2 | 46 | ||
21 | F2F INT BY BSNESS | -43735 | -43689 | |||
22 | FEEDBCK FRM BSNESS | 0 | -43689 | |||
23 | HIRE/REJECTED DT | 0 | -43689 | |||
24 | OFFER SENT TO CANDT | 0 | -43689 | |||
25 | OFFER ACPT BY CANDT | 0 | -43689 | |||
26 | VISA INITITATE DT | 0 | -43689 | |||
27 | VISA ISSUE DATE | 0 | -43689 | |||
28 | SENT TO CANDT | 0 | -43689 | |||
29 | TKT ISSUE DT | 0 | -43689 | |||
Report |