Returning dates in roster for field break, quarantine and onsite

glinsthattil

New Member
Joined
Oct 3, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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.

Name1st 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)
Remarks21-Sep-2122-Sep-2123-Sep-2124-Sep-2125-Sep-2126-Sep-2127-Sep-2128-Sep-2129-Sep-2130-Sep-2101-Oct-2102-Oct-2103-Oct-2104-Oct-2105-Oct-2106-Oct-2107-Oct-2108-Oct-2109-Oct-2110-Oct-2111-Oct-2112-Oct-2113-Oct-2114-Oct-2115-Oct-2116-Oct-2117-Oct-2118-Oct-2119-Oct-2120-Oct-2121-Oct-2122-Oct-2123-Oct-2124-Oct-2125-Oct-2126-Oct-2127-Oct-2128-Oct-2129-Oct-2130-Oct-2131-Oct-2101-Nov-2102-Nov-2103-Nov-2104-Nov-2105-Nov-2106-Nov-2107-Nov-2108-Nov-2109-Nov-2110-Nov-2111-Nov-2112-Nov-2113-Nov-2114-Nov-2115-Nov-2116-Nov-2117-Nov-2118-Nov-2119-Nov-2120-Nov-2121-Nov-2122-Nov-2123-Nov-2124-Nov-2125-Nov-2126-Nov-2127-Nov-2128-Nov-2129-Nov-2130-Nov-2101-Dec-2102-Dec-2103-Dec-2104-Dec-2105-Dec-2106-Dec-2107-Dec-2108-Dec-2109-Dec-2110-Dec-2111-Dec-2112-Dec-2113-Dec-2114-Dec-2115-Dec-2116-Dec-2117-Dec-2118-Dec-2119-Dec-2120-Dec-2121-Dec-2122-Dec-2123-Dec-2124-Dec-2125-Dec-2126-Dec-2127-Dec-2128-Dec-2129-Dec-2130-Dec-2131-Dec-2101-Jan-2202-Jan-2203-Jan-2204-Jan-2205-Jan-2206-Jan-2207-Jan-2208-Jan-2209-Jan-2210-Jan-2211-Jan-2212-Jan-2213-Jan-2214-Jan-2215-Jan-2216-Jan-2217-Jan-2218-Jan-2219-Jan-2220-Jan-2221-Jan-2222-Jan-2223-Jan-2224-Jan-2225-Jan-2226-Jan-2227-Jan-2228-Jan-2229-Jan-2230-Jan-2231-Jan-2201-Feb-2202-Feb-2203-Feb-2204-Feb-2205-Feb-2206-Feb-2207-Feb-2208-Feb-2209-Feb-2210-Feb-2211-Feb-2212-Feb-2213-Feb-2214-Feb-2215-Feb-2216-Feb-2217-Feb-2218-Feb-2219-Feb-2220-Feb-2221-Feb-2222-Feb-2223-Feb-2224-Feb-2225-Feb-2226-Feb-2227-Feb-2228-Feb-2201-Mar-2202-Mar-2203-Mar-2204-Mar-2205-Mar-2206-Mar-2207-Mar-2208-Mar-2209-Mar-2210-Mar-2211-Mar-2212-Mar-2213-Mar-2214-Mar-2215-Mar-2216-Mar-2217-Mar-2218-Mar-2219-Mar-2220-Mar-2221-Mar-2222-Mar-2223-Mar-2224-Mar-2225-Mar-2226-Mar-2227-Mar-2228-Mar-2229-Mar-2230-Mar-2231-Mar-2201-Apr-2202-Apr-2203-Apr-2204-Apr-2205-Apr-2206-Apr-2207-Apr-2208-Apr-2209-Apr-2210-Apr-2211-Apr-2212-Apr-2213-Apr-2214-Apr-2215-Apr-2216-Apr-2217-Apr-2218-Apr-2219-Apr-2220-Apr-2221-Apr-2222-Apr-2223-Apr-2224-Apr-2225-Apr-2226-Apr-2227-Apr-2228-Apr-2229-Apr-2230-Apr-2201-May-2202-May-2203-May-2204-May-2205-May-2206-May-2207-May-2208-May-2209-May-2210-May-2211-May-2212-May-2213-May-2214-May-2215-May-2216-May-2217-May-2218-May-2219-May-2220-May-2221-May-2222-May-2223-May-2224-May-2225-May-2226-May-2227-May-2228-May-2229-May-2230-May-2231-May-2201-Jun-2202-Jun-2203-Jun-2204-Jun-2205-Jun-2206-Jun-2207-Jun-2208-Jun-2209-Jun-2210-Jun-2211-Jun-2212-Jun-2213-Jun-2214-Jun-2215-Jun-2216-Jun-2217-Jun-2218-Jun-2219-Jun-2220-Jun-2221-Jun-2222-Jun-2223-Jun-2224-Jun-2225-Jun-2226-Jun-2227-Jun-2228-Jun-2229-Jun-2230-Jun-2201-Jul-2202-Jul-2203-Jul-2204-Jul-2205-Jul-2206-Jul-2207-Jul-2208-Jul-2209-Jul-2210-Jul-2211-Jul-2212-Jul-2213-Jul-2214-Jul-2215-Jul-2216-Jul-2217-Jul-2218-Jul-2219-Jul-2220-Jul-2221-Jul-2222-Jul-2223-Jul-2224-Jul-2225-Jul-22
Employee 11) 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.
FBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBQPQPDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBQPQPDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBQPQPDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDFBFBFBFBFBFBFB
Employee 21) 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.
DDDDDDDDDDDDDDDDDDDDDDDDDDDDFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBQPQPDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBQPQPDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBQPQPDDDDD
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,392
Messages
5,769,807
Members
425,573
Latest member
AmroK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top