Hello guys,
I am trying to figure out formula that will show number of my work day in week, I don't have standard schedule.
Instead i can work Mon,Tue,OFF,Thu,Fri,OFF,Sun or it can be: Mon,OFF, Tue, HOLIDAY,OFF, Fri,Sat,Sun.
Networkday - only counts total days, workday - also doesn't give what i want.
Like on the table below, 2nd column is final result of formula what i am trying to acomplish.
<tbody>
</tbody>etc...
I am trying to figure out formula that will show number of my work day in week, I don't have standard schedule.
Instead i can work Mon,Tue,OFF,Thu,Fri,OFF,Sun or it can be: Mon,OFF, Tue, HOLIDAY,OFF, Fri,Sat,Sun.
Networkday - only counts total days, workday - also doesn't give what i want.
Like on the table below, 2nd column is final result of formula what i am trying to acomplish.
Monday | 1 |
Tuesday | 2 |
Wednesday | 3 |
OFF | |
Friday | 4 |
OFF | |
Sunday | 5 |
Monday | 1 |
HOLIDAY | |
Wednesday | 2 |
Thurday | 3 |
OFF | |
OFF | |
Sunday | 4 |
Monday | 1 |
<tbody>
</tbody>