create plan for point analysis accoding to weekend and holiday

**mazan2010** · 07-30-2016, 11:10 AM

Hello all
i would like to create automatic plan like in my water sampling plan sheet according to select from drop down in the same sheet in cell A2, B2, C2 and according to
water refer sheet
and every year will put holiday
the concept is some of them taken at first day of week and other one second day and other at third day and so on and will repeat in the same manner
please kindly find attached file

**dflak** · 08-01-2016, 10:36 AM

I assume the objective is to read the date in column F and give the date next due.

Please explain what the M, P, C in column G stand for and how they relate to the schedule.

I further assume that if a due date falls on a holiday, then the test gets conducted the following day. If this happens, and the test is on a two-day cycle, do we cut the time short by a day to put it back on schedule, or is the test due two days after the last test even though the last test was a day late?

**mazan2010** · 08-01-2016, 01:03 PM

regarding to M,P,C its just name for the test
i need formula in column F but related to working day (exclude weekend (friday and saturady) and holidays from sheet refer)

**dflak** · 08-01-2016, 01:19 PM

How do I determine which day of the week a test is due on?

Also what is the first day of the week for this plan?

Assuming that Sunday is the first day of the week, how do you want to determine the first week? Will it be the week that first contains a Sunday? Also some months will have 5 Sundays.