Returning dates in roster for field break, quarantine and onsite

glinsthattil · Oct 3, 2021

Hi All,

I am using a excel sheet (roster) to monitor employees field break, onsite and quarantine dates for 2 future trips. It required,
1) 1st field break date or 1st quarantine date or 1st onsite date
2) 2nd field break date or 2nd quarantine date or 2nd onsite date
3) 3rd field break date or 3rd quarantine date or 3rd onsite date

I have uploaded as sample file with 2 employees details.

Looking to solve with formulas.

Name

1st field break date
(1)

1st quarantine date
(1)

1st onsite date
(1)

2nd field break date
(2)

2nd quarantine date
(2)

2nd onsite date
(2)

3rd field break date
(3)

3rd quarantine date
(3)

3rd onsite date
(3)

Remarks

21-Sep-21

22-Sep-21

23-Sep-21

24-Sep-21

25-Sep-21

26-Sep-21

27-Sep-21

28-Sep-21

29-Sep-21

30-Sep-21

01-Oct-21

02-Oct-21

03-Oct-21

04-Oct-21

05-Oct-21

06-Oct-21

07-Oct-21

08-Oct-21

09-Oct-21

10-Oct-21

11-Oct-21

12-Oct-21

13-Oct-21

14-Oct-21

15-Oct-21

16-Oct-21

17-Oct-21

18-Oct-21

19-Oct-21

20-Oct-21

21-Oct-21

22-Oct-21

23-Oct-21

24-Oct-21

25-Oct-21

26-Oct-21

27-Oct-21

28-Oct-21

29-Oct-21

30-Oct-21

31-Oct-21

01-Nov-21

02-Nov-21

03-Nov-21

04-Nov-21

05-Nov-21

06-Nov-21

07-Nov-21

08-Nov-21

09-Nov-21

10-Nov-21

11-Nov-21

12-Nov-21

13-Nov-21

14-Nov-21

15-Nov-21

16-Nov-21

17-Nov-21

18-Nov-21

19-Nov-21

20-Nov-21

21-Nov-21

22-Nov-21

23-Nov-21

24-Nov-21

25-Nov-21

26-Nov-21

27-Nov-21

28-Nov-21

29-Nov-21

30-Nov-21

01-Dec-21

02-Dec-21

03-Dec-21

04-Dec-21

05-Dec-21

06-Dec-21

07-Dec-21

08-Dec-21

09-Dec-21

10-Dec-21

11-Dec-21

12-Dec-21

13-Dec-21

14-Dec-21

15-Dec-21

16-Dec-21

17-Dec-21

18-Dec-21

19-Dec-21

20-Dec-21

21-Dec-21

22-Dec-21

23-Dec-21

24-Dec-21

25-Dec-21

26-Dec-21

27-Dec-21

28-Dec-21

29-Dec-21

30-Dec-21

31-Dec-21

01-Jan-22

02-Jan-22

03-Jan-22

04-Jan-22

05-Jan-22

06-Jan-22

07-Jan-22

08-Jan-22

09-Jan-22

10-Jan-22

11-Jan-22

12-Jan-22

13-Jan-22

14-Jan-22

15-Jan-22

16-Jan-22

17-Jan-22

18-Jan-22

19-Jan-22

20-Jan-22

21-Jan-22

22-Jan-22

23-Jan-22

24-Jan-22

25-Jan-22

26-Jan-22

27-Jan-22

28-Jan-22

29-Jan-22

30-Jan-22

31-Jan-22

01-Feb-22

02-Feb-22

03-Feb-22

04-Feb-22

05-Feb-22

06-Feb-22

07-Feb-22

08-Feb-22

09-Feb-22

10-Feb-22

11-Feb-22

12-Feb-22

13-Feb-22

14-Feb-22

15-Feb-22

16-Feb-22

17-Feb-22

18-Feb-22

19-Feb-22

20-Feb-22

21-Feb-22

22-Feb-22

23-Feb-22

24-Feb-22

25-Feb-22

26-Feb-22

27-Feb-22

28-Feb-22

01-Mar-22

02-Mar-22

03-Mar-22

04-Mar-22

05-Mar-22

06-Mar-22

07-Mar-22

08-Mar-22

09-Mar-22

10-Mar-22

11-Mar-22

12-Mar-22

13-Mar-22

14-Mar-22

15-Mar-22

16-Mar-22

17-Mar-22

18-Mar-22

19-Mar-22

20-Mar-22

21-Mar-22

22-Mar-22

23-Mar-22

24-Mar-22

25-Mar-22

26-Mar-22

27-Mar-22

28-Mar-22

29-Mar-22

30-Mar-22

31-Mar-22

01-Apr-22

02-Apr-22

03-Apr-22

04-Apr-22

05-Apr-22

06-Apr-22

07-Apr-22

08-Apr-22

09-Apr-22

10-Apr-22

11-Apr-22

12-Apr-22

13-Apr-22

14-Apr-22

15-Apr-22

16-Apr-22

17-Apr-22

18-Apr-22

19-Apr-22

20-Apr-22

21-Apr-22

22-Apr-22

23-Apr-22

24-Apr-22

25-Apr-22

26-Apr-22

27-Apr-22

28-Apr-22

29-Apr-22

30-Apr-22

01-May-22

02-May-22

03-May-22

04-May-22

05-May-22

06-May-22

07-May-22

08-May-22

09-May-22

10-May-22

11-May-22

12-May-22

13-May-22

14-May-22

15-May-22

16-May-22

17-May-22

18-May-22

19-May-22

20-May-22

21-May-22

22-May-22

23-May-22

24-May-22

25-May-22

26-May-22

27-May-22

28-May-22

29-May-22

30-May-22

31-May-22

01-Jun-22

02-Jun-22

03-Jun-22

04-Jun-22

05-Jun-22

06-Jun-22

07-Jun-22

08-Jun-22

09-Jun-22

10-Jun-22

11-Jun-22

12-Jun-22

13-Jun-22

14-Jun-22

15-Jun-22

16-Jun-22

17-Jun-22

18-Jun-22

19-Jun-22

20-Jun-22

21-Jun-22

22-Jun-22

23-Jun-22

24-Jun-22

25-Jun-22

26-Jun-22

27-Jun-22

28-Jun-22

29-Jun-22

30-Jun-22

01-Jul-22

02-Jul-22

03-Jul-22

04-Jul-22

05-Jul-22

06-Jul-22

07-Jul-22

08-Jul-22

09-Jul-22

10-Jul-22

11-Jul-22

12-Jul-22

13-Jul-22

14-Jul-22

15-Jul-22

16-Jul-22

17-Jul-22

18-Jul-22

19-Jul-22

20-Jul-22

21-Jul-22

22-Jul-22

23-Jul-22

24-Jul-22

25-Jul-22

Employee 1

1) Currently in field break, returning to quarantine on 17 Oct 21 and 19 Oct 21 onsite.
2) Start field break on 07 Dec 21, 30 Jan 22 in quarantine and 01 Feb 22 onsite.
3) Start qurantine on 22 May 22, 24 May 22 onsite and 19 July 22 start field break.

FB

QP

D

FB

QP

D

FB

QP

D

FB

Employee 2

1) Currently in onsite, start field break on 19 Oct 21 and 05 Dec 21 in quarantine.
2) Start onsite on 07 Dec 21, 01 Feb 22 start field break and 27 Mar 22 in quarantine.
3) Start onsite on 29 Mar 22, 24 May 22 start field break and 19 July 22 in quarantine.

D

FB

QP

D

FB

QP

D

FB

QP

D

Returning dates in roster for field break, quarantine and onsite

glinsthattil

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

Returning dates in roster for field break, quarantine and onsite

glinsthattil

New Member

Excel Facts

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock