Dear Expert
i have two cases
first if the date in column A is first working day and column E contain Value 2
the result must be as the following
I2+J2
second if the date in column A is first working day and column E contain Value 1
the result must be as the following
I2
second case
first if the date in column A is Not first working day and column E contain Value 2
the result must be as the following
I3+J3
first if the date in column A is Not first working day and column E contain Value 1
the result must be as the following
I3
the result like in column F in my attached file
Bookmarks